{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Input","Calving input","Culling rate","Output","Output charts","Outputs for chart","Hidden calculation original","Hidden calculation alter","Yields for charts","Lists"],"not_rendered":{"charts":8,"images":2,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,1,51,6],[52,1,52,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6],[50,1,50,6]]}
["Milk Forecasting Calculator Instructions"]
["This tool enables you to create a milk production and sales income forecast for up to 3 years from your yield and expected calvings. "]
["It also allows you to see the impact of changing yield, calvings, lactation curve or lactation period on your milk production and milk sales income."]
[]
["Input is via the \"Input\" and \"Calving Input\" sheets, and entries are required in all white cells."]
["Please note, if you only want to do a 1 year milk forecast, you can leave the Calving Input sheet blank for years 2 and 3"]
[]
["Entry on Input sheet"]
["On the Input sheet - select the start month for your year 1 forecast from the drop down list."]
["Enter your annual milk production for the last 12 months - ideally running up to the start of the date you entered above"]
["Enter the total number of cows (including heifers-in-milk) in your herd at the start of the year."]
["Enter your typical calving interval (in days)"]
["Enter your typical dry period (in days)"]
["Select a shape of lactation curve from the drop down list that suits your system. The chart on the Input sheet will change, depending on which curve you choose."]
["Try different curves as selecting the wrong one can make very large difference to the pattern of milk output, although overall lacation yields will be very similar."]
["Enter your heifer-in-milk yield as a percentage of what you achieve for cows-in-milk. If heifer and cow yields are similar, enter 100% in this cell."]
["The spreadsheet will calculate an estimate for your average yield per cow-in-milk based on the numbers you entered above."]
["You can either use this calculated number or enter your own figure for yield per cow in milk in the white cell."]
["If you plan to increase or decrease milk yield over the coming years, enter the rate of change as a %."]
["If milk yield per cow is expected to reduce, enter a negative number."]
["If you do not plan to change your yield over the period, then please enter 0 in this cell"]
["The spreadsheet will show you what your milk yield will be at the end of year 3 based on the percentage change you have entered."]
[]
["If you want to look at the impact of changes on farm, you can enter data in the alternative scenario cells and a comparison will be done."]
[]
["Entry on Calving Input sheet"]
["You will need to enter the number of cows and heifers who calved each month last year."]
["Also then enter the number of cows and heifers you expect to calve each month for the next 3 years."]
["Please note, if you only want to do a 1 year milk forecast, you can leave the Calving Input sheet blank for years 2 and 3"]
["In order to get an estimate of milk revenue and feed requirements, enter your estimated milk price, feed price and feed rate."]
[]
["Entry on Culling rate sheet"]
["The Culling rate sheet allows you to add details of culling rates. For example, if you have historically had to cull out 5% of your cows 6 months after calving, you"]
["can enter those details onto this sheet. In such circumstances, you would add 5% in for month 6 and leave everything else as zero."]
["It is worth noting that putting anything other than zero in this sheet will also impact on the number of cows-in-milk in any particular month. "]
["The numbers used will be applied to historic calvings as well as future calvings"]
[]
["Outputs"]
["The milk forecast is created automatically as you enter numbers. This forecast will appear on the Output sheet."]
["The milk forecast, milk revenue, milk yield and margin over feed are also shown on charts on the Output Charts sheet."]
[]
["Typical profile types"]
["Copy the typical profile name from below and paste into the typical profile boxes in the input tab."]
[]
["Name","Decription"]
["Feed to yield","High Peak yield and reduce feed as milk yields fall ,eg normal parlour feeding"]
["Step rate","High peaks but cows fed in steps according to stage of lactation not yield"]
["Flat rate","Lower peaks with one fixed level of concentrates fed to all cows"]
["Total mixed ration","One mixed ration fed to all milking cows"]
["Three times a day milking","TMR or partial mixed diet plus cake with 3x a day or robotic milking "]
["Once a day milking","Predominantly grazing system but cows only milked once per day"]
["Spring block","Intensively grazed, grass based system"]
["Autumn block","Herd fed to achieve maximum yield in winter and maximise grazing in spring"]

{"sheet":"Input","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,10],[18,7,19,11],[33,7,34,11]]}
["Milk Forecasting Calculator"]
[]
["This tool enables you to create a milk production and sales income forecast for up to 3 years from your yield and expected calvings. "]
["It also allows you to see the impact of changing yield, calvings, lactation curve or lactation period on your milk production and milk sales income."]
["For instructions please refer to the \"Instructions\" sheet."]
[]
[{"$nulls":5},"Current scenario"]
[]
[{"$nulls":4},"Start month of forecast   ","2019-04-30"]
[{"$nulls":4},"Current annual milk production   ",1000000,"litres"]
[{"$nulls":4},{"$f":"CONCATENATE(\"Number of cows in herd at start of \",TEXT(F9,\"mmm-yy\"),\"   \")","v":"Number of cows in herd at start of Apr-19   "},156,"cows"]
[{"$nulls":4},"Current typical calving interval   ",365,"days"]
[{"$nulls":4},"Typical dry period   ",60,"days"]
[{"$nulls":4},"Typical profile   ","Feed to yield"]
[{"$nulls":4},"Heifer yield as % of cow yield   ",0.85,"%"]
[]
[{"$nulls":4},"Estimated current yield per cow in milk   ",{"$f":"F10/ROUND(F11*(F12-F13)/F12,0)","v":7692.3076923076924},"litres"]
[{"$nulls":4},"Current yield per cow in milk to be used   ",{"$f":"F17","v":7692.3076923076924},"litres"]
[{"$nulls":4},"Planned annual increase in yield   ",0,"%",{"$f":"CONCATENATE(F14,\" - \",HLOOKUP(F14,'Yields for charts'!$B$20:$Q$21,2,FALSE))","v":"Feed to yield - High Peak yield and reduce feed as milk yields fall, e.g. normal parlour feeding"}]
[{"$nulls":4},"Estimated yield per cow in milk at end of year 3   ",{"$f":"F18*(1+F19)^3","v":7692.3076923076924},"litres"]
[]
[]
[{"$nulls":5},"Alternative scenario"]
[]
[{"$nulls":4},"Typical calving interval   ",365,"days"]
[{"$nulls":4},"Typical dry period   ",60,"days"]
[{"$nulls":4},"Typical profile   ","Feed to yield"]
[]
[{"$nulls":4},"Estimated yield per cow in milk   ",{"$f":"F10/ROUND(F11*(F25-F26)/F25,0)","v":7692.3076923076924},"litres"]
[{"$nulls":4},"Current yield per cow in milk to be used   ",{"$f":"F29","v":7692.3076923076924},"litres"]
[{"$nulls":4},"Planned annual increase/decrease in yield   ",0,"%"]
[{"$nulls":4},"Estimated yield per cow in milk at end of year 3   ",{"$f":"F30*(1+F31)^3","v":7692.3076923076924},"litres"]
[]
[{"$nulls":7},{"$f":"CONCATENATE(F27,\" - \",HLOOKUP(F27,'Yields for charts'!$B$20:$Q$21,2,FALSE))","v":"Feed to yield - High Peak yield and reduce feed as milk yields fall, e.g. normal parlour feeding"}]
[]
[]
["AHDB Dairy is a division of the Agricultural and Horticultural Development Board."]
["While the Agriculture and Horticulture Development Board seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law, the Agriculture and Horticulture Development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document. "]

{"sheet":"Calving input","index":2,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[43,0,54,0],[1,2,1,6],[1,7,1,11],[4,0,15,0],[17,0,28,0],[30,0,41,0]]}
[null,null,"Milk Forecasting Calculator",{"$nulls":4},"Milk Forecasting Calculator"]
[null,null,"Current scenario",{"$nulls":4},"Alternative scenario"]
[null,"Month","Heifer calvings","Cow calvings","Milk price","Feed cost","Feed rate","Heifer calvings","Cow calvings","Milk price","Feed cost","Feed rate"]
[null,null,"in month","in month","ppl","£ per kg","kgs per cow-in-milk per day","in month","in month","ppl","£ per kg","kgs per cow-in-milk per day"]
["LAST YEAR",{"$f":"EOMONTH(B6,-1)","v":"2018-04-30"},3,10,null,null,null,3,10]
[null,"2018-05-31",{"$f":"C5","v":3},{"$f":"D5","v":10},null,null,null,{"$f":"H5","v":3},{"$f":"I5","v":10}]
[null,"2018-06-30",{"$f":"C6","v":3},10,null,null,null,{"$f":"H6","v":3},10]
[null,"2018-07-31",3,10,null,null,null,3,10]
[null,"2018-08-31",3,10,null,null,null,3,10]
[null,"2018-09-30",3,10,null,null,null,3,10]
[null,"2018-10-31",3,10,null,null,null,3,10]
[null,"2018-11-30",3,10,null,null,null,3,10]
[null,"2018-12-31",3,10,null,null,null,3,10]
[null,"2019-01-31",3,10,null,null,null,3,10]
[null,"2019-02-28",3,10,null,null,null,3,10]
[null,{"$f":"EOMONTH(B18,-1)","v":"2019-03-31"},3,10,null,null,null,3,10]
[null,"Year",{"$f":"SUM(C5:C16)","v":36},{"$f":"SUM(D5:D16)","v":120},null,null,null,{"$f":"SUM(H5:H16)","v":36},{"$f":"SUM(I5:I16)","v":120}]
["FIRST YEAR TO FORECAST",{"$f":"Input!F9","v":"2019-04-30"},{"$f":"C5","v":3},{"$f":"D5","v":10},28,0.2,7.4,3,10,28,0.2,7.4]
[null,{"$f":"EOMONTH(B18,1)","v":"2019-05-31"},{"$f":"C6","v":3},10,{"$f":"E18","v":28},{"$f":"F18","v":0.2},{"$f":"G18","v":7.4},3,10,28,0.2,7.4]
[null,{"$f":"EOMONTH(B19,1)","v":"2019-06-30"},3,10,{"$f":"E19","v":28},0.2,7.4,3,10,28,0.2,7.4]
[null,"2019-07-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2019-08-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2019-09-30",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2019-10-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2019-11-30",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2019-12-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-01-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-02-29",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-03-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"Year",{"$f":"SUM(C18:C29)","v":36},{"$f":"SUM(D18:D29)","v":120},null,null,null,{"$f":"SUM(H18:H29)","v":36},{"$f":"SUM(I18:I29)","v":120}]
["2ND YEAR TO FORECAST",{"$f":"EOMONTH(B29,1)","v":"2020-04-30"},{"$f":"C18","v":3},{"$f":"D18","v":10},28,0.2,7.4,3,10,28,0.2,7.4]
[null,{"$f":"EOMONTH(B31,1)","v":"2020-05-31"},{"$f":"C19","v":3},10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,{"$f":"EOMONTH(B32,1)","v":"2020-06-30"},3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-07-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-08-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-09-30",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-10-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-11-30",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2020-12-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-01-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-02-28",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-03-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"Year",{"$f":"SUM(C31:C42)","v":36},{"$f":"SUM(D31:D42)","v":120},null,null,null,{"$f":"SUM(H31:H42)","v":36},{"$f":"SUM(I31:I42)","v":120}]
["3RD YEAR TO FORECAST",{"$f":"EOMONTH(B42,1)","v":"2021-04-30"},{"$f":"C31","v":3},{"$f":"D31","v":10},28,0.2,7.4,3,10,28,0.2,7.4]
[null,{"$f":"EOMONTH(B44,1)","v":"2021-05-31"},{"$f":"C32","v":3},10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,{"$f":"EOMONTH(B45,1)","v":"2021-06-30"},3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-07-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-08-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-09-30",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-10-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-11-30",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2021-12-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2022-01-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2022-02-28",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"2022-03-31",3,10,28,0.2,7.4,3,10,28,0.2,7.4]
[null,"Year",{"$f":"SUM(C44:C55)","v":36},{"$f":"SUM(D44:D55)","v":120},null,null,null,{"$f":"SUM(H44:H55)","v":36},{"$f":"SUM(I44:I55)","v":120}]

{"sheet":"Culling rate","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,3,0],[0,5,0,8],[0,1,0,4],[1,1,1,2],[1,3,1,4],[2,1,2,2],[2,3,2,4],[2,5,2,6],[1,5,1,6],[1,7,1,8],[2,7,2,8]]}
[null,"Milk Forecasting Calculator",null,null,null,"Milk Forecasting Calculator"]
[null,"Current scenario",null,"Alternative scenario",null,"Current scenario",null,"Alternative scenario"]
["Month of lactation","Culling rates",null,"Culling rates",null,"Proportion of animals still milking",null,"Proportion of animals still milking"]
[null,"Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows"]
[1,0,0,0,0,{"$f":"1-B5","v":1},{"$f":"1-C5","v":1},{"$f":"1-D5","v":1},{"$f":"1-E5","v":1}]
[2,0,0,0,0,{"$f":"F5*(1-B6)","v":1},{"$f":"G5*(1-C6)","v":1},{"$f":"H5*(1-D6)","v":1},{"$f":"I5*(1-E6)","v":1}]
[3,0,0,0,0,{"$f":"F6*(1-B7)","v":1},1,1,1]
[4,0,0,0,0,1,1,1,1]
[5,0,0,0.2,0.2,1,1,0.8,0.8]
[6,0,0,0.2,0.2,1,1,0.64000000000000012,0.64000000000000012]
[7,0,0,0.2,0.2,1,1,0.51200000000000012,0.51200000000000012]
[8,0,0,1,1,1,1,0,0]
[9,0,0,0,0,1,1,0,0]
[10,0,0,0,0,1,1,0,0]
[11,0,0,0,0,1,1,0,0]
[12,0,0,0,0,1,1,0,0]
[13,0,0,0,0,1,1,0,0]
[14,0,0,0,0,1,1,0,0]

{"sheet":"Output","index":4,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Milk Forecasting Calculator Outputs",{"$nulls":7},"Milk Forecasting Calculator Outputs"]
[null,"Current Scenario Forecast",{"$nulls":7},"Alternative Scenario Forecast"]
[null,"Lactation curve:",null,null,{"$f":"CONCATENATE(\" \",Input!F14)","v":" Feed to yield"},{"$nulls":4},"Lactation curve:",null,null,{"$f":"CONCATENATE(\" \",Input!F27)","v":" Feed to yield"}]
[null,"Typical lactation period:",null,null,{"$f":"CONCATENATE(\" \",Input!F12, \" days\")","v":" 365 days"},{"$nulls":4},"Typical lactation period:",null,null,{"$f":"CONCATENATE(\" \",Input!F25, \" days\")","v":" 365 days"}]
[null,"Typical dry period:",null,null,{"$f":"CONCATENATE(\" \",Input!F13, \" days\")","v":" 60 days"},{"$nulls":4},"Typical dry period:",null,null,{"$f":"CONCATENATE(\" \",Input!F26, \" days\")","v":" 60 days"}]
[null,"Days","Cows in Milk","Total milk produced (litres)","Daily yield per cow in milk (litres)","Total milk revenue (£)","Concentrate used (kgs / mth)","Concentrate cost (£)","Manual seasonal adjustment","Cows in Milk","Total milk produced (litres)","Daily yield per cow in milk (litres)","Total milk revenue (£)","Concentrate used (kgs / mth)","Concentrate cost (£)","Manual seasonal adjustment","Total milk versus current (l)"]
[{"$f":"Input!F9","v":"2019-04-30"},{"$f":"DAY(A7)","v":30},{"$f":"'Hidden calculation original'!S5+'Hidden calculation original'!AJ5","v":130},{"$f":"'Hidden calculation original'!AV5*Output!I7*B7","v":82191.780821917826},{"$f":"IF(C7=0,0,D7/$B7/C7)","v":21.074815595363546},{"$f":"D7*'Calving input'!E18/100","v":23013.698630136991},{"$f":"C7*'Calving input'!G18*B7","v":28860},{"$f":"G7*'Calving input'!F18","v":5772},1,{"$f":"'Hidden calculation alter'!S5+'Hidden calculation alter'!AJ5","v":78},{"$f":"'Hidden calculation alter'!AV5*P7*B7","v":56733.731966727479},{"$f":"IF(J7=0,0,K7/B7/J7)","v":24.24518460116559},{"$f":"K7*'Calving input'!J18/100","v":15885.444950683694},{"$f":"J7*'Calving input'!L18*B7","v":17316},{"$f":"N7*'Calving input'!K18","v":3463.2000000000003},1,{"$f":"K7-D7","v":-25458.048855190347}]
[{"$f":"EOMONTH(A7,1)","v":"2019-05-31"},{"$f":"DAY(A8)","v":31},{"$f":"'Hidden calculation original'!S6+'Hidden calculation original'!AJ6","v":130},{"$f":"'Hidden calculation original'!AV6*Output!I8*B8","v":84931.50684931509},{"$f":"IF(C8=0,0,D8/$B8/C8)","v":21.074815595363546},{"$f":"D8*'Calving input'!E19/100","v":23780.821917808222},{"$f":"C8*'Calving input'!G19*B8","v":29822},{"$f":"G8*'Calving input'!F19","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S6+'Hidden calculation alter'!AJ6","v":78},{"$f":"'Hidden calculation alter'!AV6*P8*B8","v":58624.856365618391},24.24518460116559,{"$f":"K8*'Calving input'!J19/100","v":16414.959782373149},{"$f":"J8*'Calving input'!L19*B8","v":17893.2},{"$f":"N8*'Calving input'!K19","v":3578.6400000000003},1,-26306.6504836967]
["2019-06-30",30,{"$f":"'Hidden calculation original'!S7+'Hidden calculation original'!AJ7","v":130},{"$f":"'Hidden calculation original'!AV7*Output!I9*B9","v":82191.780821917826},21.074815595363546,{"$f":"D9*'Calving input'!E20/100","v":23013.698630136991},{"$f":"C9*'Calving input'!G20*B9","v":28860},{"$f":"G9*'Calving input'!F20","v":5772},1,{"$f":"'Hidden calculation alter'!S7+'Hidden calculation alter'!AJ7","v":78},{"$f":"'Hidden calculation alter'!AV7*P9*B9","v":56733.731966727479},24.24518460116559,{"$f":"K9*'Calving input'!J20/100","v":15885.444950683694},{"$f":"J9*'Calving input'!L20*B9","v":17316},{"$f":"N9*'Calving input'!K20","v":3463.2000000000003},1,-25458.048855190347]
["2019-07-31",31,{"$f":"'Hidden calculation original'!S8+'Hidden calculation original'!AJ8","v":130},{"$f":"'Hidden calculation original'!AV8*Output!I10*B10","v":84931.50684931509},21.074815595363546,{"$f":"D10*'Calving input'!E21/100","v":23780.821917808222},{"$f":"C10*'Calving input'!G21*B10","v":29822},{"$f":"G10*'Calving input'!F21","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S8+'Hidden calculation alter'!AJ8","v":78},{"$f":"'Hidden calculation alter'!AV8*P10*B10","v":58624.856365618391},24.24518460116559,{"$f":"K10*'Calving input'!J21/100","v":16414.959782373149},{"$f":"J10*'Calving input'!L21*B10","v":17893.2},{"$f":"N10*'Calving input'!K21","v":3578.6400000000003},1,-26306.6504836967]
["2019-08-31",31,{"$f":"'Hidden calculation original'!S9+'Hidden calculation original'!AJ9","v":130},{"$f":"'Hidden calculation original'!AV9*Output!I11*B11","v":84931.50684931509},21.074815595363546,{"$f":"D11*'Calving input'!E22/100","v":23780.821917808222},{"$f":"C11*'Calving input'!G22*B11","v":29822},{"$f":"G11*'Calving input'!F22","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S9+'Hidden calculation alter'!AJ9","v":78},{"$f":"'Hidden calculation alter'!AV9*P11*B11","v":58624.856365618391},24.24518460116559,{"$f":"K11*'Calving input'!J22/100","v":16414.959782373149},{"$f":"J11*'Calving input'!L22*B11","v":17893.2},{"$f":"N11*'Calving input'!K22","v":3578.6400000000003},1,-26306.6504836967]
["2019-09-30",30,{"$f":"'Hidden calculation original'!S10+'Hidden calculation original'!AJ10","v":130},{"$f":"'Hidden calculation original'!AV10*Output!I12*B12","v":82191.780821917826},21.074815595363546,{"$f":"D12*'Calving input'!E23/100","v":23013.698630136991},{"$f":"C12*'Calving input'!G23*B12","v":28860},{"$f":"G12*'Calving input'!F23","v":5772},1,{"$f":"'Hidden calculation alter'!S10+'Hidden calculation alter'!AJ10","v":78},{"$f":"'Hidden calculation alter'!AV10*P12*B12","v":56733.731966727479},24.24518460116559,{"$f":"K12*'Calving input'!J23/100","v":15885.444950683694},{"$f":"J12*'Calving input'!L23*B12","v":17316},{"$f":"N12*'Calving input'!K23","v":3463.2000000000003},1,-25458.048855190347]
["2019-10-31",31,{"$f":"'Hidden calculation original'!S11+'Hidden calculation original'!AJ11","v":130},{"$f":"'Hidden calculation original'!AV11*Output!I13*B13","v":84931.50684931509},21.074815595363546,{"$f":"D13*'Calving input'!E24/100","v":23780.821917808222},{"$f":"C13*'Calving input'!G24*B13","v":29822},{"$f":"G13*'Calving input'!F24","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S11+'Hidden calculation alter'!AJ11","v":78},{"$f":"'Hidden calculation alter'!AV11*P13*B13","v":58624.856365618391},24.24518460116559,{"$f":"K13*'Calving input'!J24/100","v":16414.959782373149},{"$f":"J13*'Calving input'!L24*B13","v":17893.2},{"$f":"N13*'Calving input'!K24","v":3578.6400000000003},1,-26306.6504836967]
["2019-11-30",30,{"$f":"'Hidden calculation original'!S12+'Hidden calculation original'!AJ12","v":130},{"$f":"'Hidden calculation original'!AV12*Output!I14*B14","v":82191.780821917826},21.074815595363546,{"$f":"D14*'Calving input'!E25/100","v":23013.698630136991},{"$f":"C14*'Calving input'!G25*B14","v":28860},{"$f":"G14*'Calving input'!F25","v":5772},1,{"$f":"'Hidden calculation alter'!S12+'Hidden calculation alter'!AJ12","v":78},{"$f":"'Hidden calculation alter'!AV12*P14*B14","v":56733.731966727479},24.24518460116559,{"$f":"K14*'Calving input'!J25/100","v":15885.444950683694},{"$f":"J14*'Calving input'!L25*B14","v":17316},{"$f":"N14*'Calving input'!K25","v":3463.2000000000003},1,-25458.048855190347]
["2019-12-31",31,{"$f":"'Hidden calculation original'!S13+'Hidden calculation original'!AJ13","v":130},{"$f":"'Hidden calculation original'!AV13*Output!I15*B15","v":84931.50684931509},21.074815595363546,{"$f":"D15*'Calving input'!E26/100","v":23780.821917808222},{"$f":"C15*'Calving input'!G26*B15","v":29822},{"$f":"G15*'Calving input'!F26","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S13+'Hidden calculation alter'!AJ13","v":78},{"$f":"'Hidden calculation alter'!AV13*P15*B15","v":58624.856365618391},24.24518460116559,{"$f":"K15*'Calving input'!J26/100","v":16414.959782373149},{"$f":"J15*'Calving input'!L26*B15","v":17893.2},{"$f":"N15*'Calving input'!K26","v":3578.6400000000003},1,-26306.6504836967]
["2020-01-31",31,{"$f":"'Hidden calculation original'!S14+'Hidden calculation original'!AJ14","v":130},{"$f":"'Hidden calculation original'!AV14*Output!I16*B16","v":84931.50684931509},21.074815595363546,{"$f":"D16*'Calving input'!E27/100","v":23780.821917808222},{"$f":"C16*'Calving input'!G27*B16","v":29822},{"$f":"G16*'Calving input'!F27","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S14+'Hidden calculation alter'!AJ14","v":78},{"$f":"'Hidden calculation alter'!AV14*P16*B16","v":58624.856365618391},24.24518460116559,{"$f":"K16*'Calving input'!J27/100","v":16414.959782373149},{"$f":"J16*'Calving input'!L27*B16","v":17893.2},{"$f":"N16*'Calving input'!K27","v":3578.6400000000003},1,-26306.6504836967]
["2020-02-29",29,{"$f":"'Hidden calculation original'!S15+'Hidden calculation original'!AJ15","v":130},{"$f":"'Hidden calculation original'!AV15*Output!I17*B17","v":79452.054794520576},21.074815595363546,{"$f":"D17*'Calving input'!E28/100","v":22246.57534246576},{"$f":"C17*'Calving input'!G28*B17","v":27898},{"$f":"G17*'Calving input'!F28","v":5579.6},1,{"$f":"'Hidden calculation alter'!S15+'Hidden calculation alter'!AJ15","v":78},{"$f":"'Hidden calculation alter'!AV15*P17*B17","v":54842.60756783656},24.24518460116559,{"$f":"K17*'Calving input'!J28/100","v":15355.930118994238},{"$f":"J17*'Calving input'!L28*B17","v":16738.800000000003},{"$f":"N17*'Calving input'!K28","v":3347.7600000000007},1,-24609.447226684017]
["2020-03-31",31,{"$f":"'Hidden calculation original'!S16+'Hidden calculation original'!AJ16","v":130},{"$f":"'Hidden calculation original'!AV16*Output!I18*B18","v":84931.50684931509},21.074815595363546,{"$f":"D18*'Calving input'!E29/100","v":23780.821917808222},{"$f":"C18*'Calving input'!G29*B18","v":29822},{"$f":"G18*'Calving input'!F29","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S16+'Hidden calculation alter'!AJ16","v":78},{"$f":"'Hidden calculation alter'!AV16*P18*B18","v":58624.856365618391},24.24518460116559,{"$f":"K18*'Calving input'!J29/100","v":16414.959782373149},{"$f":"J18*'Calving input'!L29*B18","v":17893.2},{"$f":"N18*'Calving input'!K29","v":3578.6400000000003},1,-26306.6504836967]
["Year 1",{"$f":"SUM(B7:B18)","v":366},{"$f":"AVERAGE(C7:C18)","v":130},{"$f":"SUM(D7:D18)","v":1002739.7260273977},21.07481559536355,{"$f":"SUM(F7:F18)","v":280767.12328767125},{"$f":"SUM(G7:G18)","v":352092},{"$f":"SUM(H7:H18)","v":70418.400000000009},{"$f":"AVERAGE(I7:I18)","v":1},{"$f":"AVERAGE(J7:J18)","v":78},{"$f":"SUM(K7:K18)","v":692151.52999407519},24.245184601165587,{"$f":"SUM(M7:M18)","v":193802.42839834109},{"$f":"SUM(N7:N18)","v":211255.2},{"$f":"SUM(O7:O18)","v":42251.040000000001},{"$f":"AVERAGE(P7:P18)","v":1},-310588.19603332249]
[{"$nulls":4},{"$f":"E19*B19","v":7713.3825079030594},"Forecast annual yield per cow in milk",{"$nulls":5},{"$f":"L19*B19","v":8873.7375640266055},"Forecast annual yield per cow in milk"]
[]
[{"$f":"EOMONTH(A18,1)","v":"2020-04-30"},{"$f":"DAY(A22)","v":30},{"$f":"'Hidden calculation original'!S17+'Hidden calculation original'!AJ17","v":130},{"$f":"'Hidden calculation original'!AV17*Output!I22*B22","v":82191.780821917826},{"$f":"IF(C22=0,0,D22/$B22/C22)","v":21.074815595363546},{"$f":"D22*'Calving input'!E31/100","v":23013.698630136991},{"$f":"C22*'Calving input'!G31*B22","v":28860},{"$f":"G22*'Calving input'!F31","v":5772},1,{"$f":"'Hidden calculation alter'!S17+'Hidden calculation alter'!AJ17","v":78},{"$f":"'Hidden calculation alter'!AV17*P22*B22","v":56733.731966727479},{"$f":"IF(J22=0,0,K22/B22/J22)","v":24.24518460116559},{"$f":"K22*'Calving input'!J31/100","v":15885.444950683694},{"$f":"J22*'Calving input'!L31*B22","v":17316},{"$f":"N22*'Calving input'!K31","v":3463.2000000000003},1,{"$f":"K22-D22","v":-25458.048855190347}]
[{"$f":"EOMONTH(A22,1)","v":"2020-05-31"},{"$f":"DAY(A23)","v":31},{"$f":"'Hidden calculation original'!S18+'Hidden calculation original'!AJ18","v":130},{"$f":"'Hidden calculation original'!AV18*Output!I23*B23","v":84931.50684931509},{"$f":"IF(C23=0,0,D23/$B23/C23)","v":21.074815595363546},{"$f":"D23*'Calving input'!E32/100","v":23780.821917808222},{"$f":"C23*'Calving input'!G32*B23","v":29822},{"$f":"G23*'Calving input'!F32","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S18+'Hidden calculation alter'!AJ18","v":78},{"$f":"'Hidden calculation alter'!AV18*P23*B23","v":58624.856365618391},24.24518460116559,{"$f":"K23*'Calving input'!J32/100","v":16414.959782373149},{"$f":"J23*'Calving input'!L32*B23","v":17893.2},{"$f":"N23*'Calving input'!K32","v":3578.6400000000003},1,-26306.6504836967]
["2020-06-30",30,{"$f":"'Hidden calculation original'!S19+'Hidden calculation original'!AJ19","v":130},{"$f":"'Hidden calculation original'!AV19*Output!I24*B24","v":82191.780821917826},21.074815595363546,{"$f":"D24*'Calving input'!E33/100","v":23013.698630136991},{"$f":"C24*'Calving input'!G33*B24","v":28860},{"$f":"G24*'Calving input'!F33","v":5772},1,{"$f":"'Hidden calculation alter'!S19+'Hidden calculation alter'!AJ19","v":78},{"$f":"'Hidden calculation alter'!AV19*P24*B24","v":56733.731966727479},24.24518460116559,{"$f":"K24*'Calving input'!J33/100","v":15885.444950683694},{"$f":"J24*'Calving input'!L33*B24","v":17316},{"$f":"N24*'Calving input'!K33","v":3463.2000000000003},1,-25458.048855190347]
["2020-07-31",31,{"$f":"'Hidden calculation original'!S20+'Hidden calculation original'!AJ20","v":130},{"$f":"'Hidden calculation original'!AV20*Output!I25*B25","v":84931.50684931509},21.074815595363546,{"$f":"D25*'Calving input'!E34/100","v":23780.821917808222},{"$f":"C25*'Calving input'!G34*B25","v":29822},{"$f":"G25*'Calving input'!F34","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S20+'Hidden calculation alter'!AJ20","v":78},{"$f":"'Hidden calculation alter'!AV20*P25*B25","v":58624.856365618391},24.24518460116559,{"$f":"K25*'Calving input'!J34/100","v":16414.959782373149},{"$f":"J25*'Calving input'!L34*B25","v":17893.2},{"$f":"N25*'Calving input'!K34","v":3578.6400000000003},1,-26306.6504836967]
["2020-08-31",31,{"$f":"'Hidden calculation original'!S21+'Hidden calculation original'!AJ21","v":130},{"$f":"'Hidden calculation original'!AV21*Output!I26*B26","v":84931.50684931509},21.074815595363546,{"$f":"D26*'Calving input'!E35/100","v":23780.821917808222},{"$f":"C26*'Calving input'!G35*B26","v":29822},{"$f":"G26*'Calving input'!F35","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S21+'Hidden calculation alter'!AJ21","v":78},{"$f":"'Hidden calculation alter'!AV21*P26*B26","v":58624.856365618391},24.24518460116559,{"$f":"K26*'Calving input'!J35/100","v":16414.959782373149},{"$f":"J26*'Calving input'!L35*B26","v":17893.2},{"$f":"N26*'Calving input'!K35","v":3578.6400000000003},1,-26306.6504836967]
["2020-09-30",30,{"$f":"'Hidden calculation original'!S22+'Hidden calculation original'!AJ22","v":130},{"$f":"'Hidden calculation original'!AV22*Output!I27*B27","v":82191.780821917826},21.074815595363546,{"$f":"D27*'Calving input'!E36/100","v":23013.698630136991},{"$f":"C27*'Calving input'!G36*B27","v":28860},{"$f":"G27*'Calving input'!F36","v":5772},1,{"$f":"'Hidden calculation alter'!S22+'Hidden calculation alter'!AJ22","v":78},{"$f":"'Hidden calculation alter'!AV22*P27*B27","v":56733.731966727479},24.24518460116559,{"$f":"K27*'Calving input'!J36/100","v":15885.444950683694},{"$f":"J27*'Calving input'!L36*B27","v":17316},{"$f":"N27*'Calving input'!K36","v":3463.2000000000003},1,-25458.048855190347]
["2020-10-31",31,{"$f":"'Hidden calculation original'!S23+'Hidden calculation original'!AJ23","v":130},{"$f":"'Hidden calculation original'!AV23*Output!I28*B28","v":84931.50684931509},21.074815595363546,{"$f":"D28*'Calving input'!E37/100","v":23780.821917808222},{"$f":"C28*'Calving input'!G37*B28","v":29822},{"$f":"G28*'Calving input'!F37","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S23+'Hidden calculation alter'!AJ23","v":78},{"$f":"'Hidden calculation alter'!AV23*P28*B28","v":58624.856365618391},24.24518460116559,{"$f":"K28*'Calving input'!J37/100","v":16414.959782373149},{"$f":"J28*'Calving input'!L37*B28","v":17893.2},{"$f":"N28*'Calving input'!K37","v":3578.6400000000003},1,-26306.6504836967]
["2020-11-30",30,{"$f":"'Hidden calculation original'!S24+'Hidden calculation original'!AJ24","v":130},{"$f":"'Hidden calculation original'!AV24*Output!I29*B29","v":82191.780821917826},21.074815595363546,{"$f":"D29*'Calving input'!E38/100","v":23013.698630136991},{"$f":"C29*'Calving input'!G38*B29","v":28860},{"$f":"G29*'Calving input'!F38","v":5772},1,{"$f":"'Hidden calculation alter'!S24+'Hidden calculation alter'!AJ24","v":78},{"$f":"'Hidden calculation alter'!AV24*P29*B29","v":56733.731966727479},24.24518460116559,{"$f":"K29*'Calving input'!J38/100","v":15885.444950683694},{"$f":"J29*'Calving input'!L38*B29","v":17316},{"$f":"N29*'Calving input'!K38","v":3463.2000000000003},1,-25458.048855190347]
["2020-12-31",31,{"$f":"'Hidden calculation original'!S25+'Hidden calculation original'!AJ25","v":130},{"$f":"'Hidden calculation original'!AV25*Output!I30*B30","v":84931.50684931509},21.074815595363546,{"$f":"D30*'Calving input'!E39/100","v":23780.821917808222},{"$f":"C30*'Calving input'!G39*B30","v":29822},{"$f":"G30*'Calving input'!F39","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S25+'Hidden calculation alter'!AJ25","v":78},{"$f":"'Hidden calculation alter'!AV25*P30*B30","v":58624.856365618391},24.24518460116559,{"$f":"K30*'Calving input'!J39/100","v":16414.959782373149},{"$f":"J30*'Calving input'!L39*B30","v":17893.2},{"$f":"N30*'Calving input'!K39","v":3578.6400000000003},1,-26306.6504836967]
["2021-01-31",31,{"$f":"'Hidden calculation original'!S26+'Hidden calculation original'!AJ26","v":130},{"$f":"'Hidden calculation original'!AV26*Output!I31*B31","v":84931.50684931509},21.074815595363546,{"$f":"D31*'Calving input'!E40/100","v":23780.821917808222},{"$f":"C31*'Calving input'!G40*B31","v":29822},{"$f":"G31*'Calving input'!F40","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S26+'Hidden calculation alter'!AJ26","v":78},{"$f":"'Hidden calculation alter'!AV26*P31*B31","v":58624.856365618391},24.24518460116559,{"$f":"K31*'Calving input'!J40/100","v":16414.959782373149},{"$f":"J31*'Calving input'!L40*B31","v":17893.2},{"$f":"N31*'Calving input'!K40","v":3578.6400000000003},1,-26306.6504836967]
["2021-02-28",28,{"$f":"'Hidden calculation original'!S27+'Hidden calculation original'!AJ27","v":130},{"$f":"'Hidden calculation original'!AV27*Output!I32*B32","v":76712.328767123312},21.074815595363546,{"$f":"D32*'Calving input'!E41/100","v":21479.452054794529},{"$f":"C32*'Calving input'!G41*B32","v":26936},{"$f":"G32*'Calving input'!F41","v":5387.2000000000007},1,{"$f":"'Hidden calculation alter'!S27+'Hidden calculation alter'!AJ27","v":78},{"$f":"'Hidden calculation alter'!AV27*P32*B32","v":52951.483168945648},24.24518460116559,{"$f":"K32*'Calving input'!J41/100","v":14826.415287304781},{"$f":"J32*'Calving input'!L41*B32","v":16161.600000000002},{"$f":"N32*'Calving input'!K41","v":3232.3200000000006},1,-23760.845598177664]
["2021-03-31",31,{"$f":"'Hidden calculation original'!S28+'Hidden calculation original'!AJ28","v":130},{"$f":"'Hidden calculation original'!AV28*Output!I33*B33","v":84931.50684931509},21.074815595363546,{"$f":"D33*'Calving input'!E42/100","v":23780.821917808222},{"$f":"C33*'Calving input'!G42*B33","v":29822},{"$f":"G33*'Calving input'!F42","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S28+'Hidden calculation alter'!AJ28","v":78},{"$f":"'Hidden calculation alter'!AV28*P33*B33","v":58624.856365618391},24.24518460116559,{"$f":"K33*'Calving input'!J42/100","v":16414.959782373149},{"$f":"J33*'Calving input'!L42*B33","v":17893.2},{"$f":"N33*'Calving input'!K42","v":3578.6400000000003},1,-26306.6504836967]
["Year 2",{"$f":"SUM(B22:B33)","v":365},{"$f":"AVERAGE(C22:C33)","v":130},{"$f":"SUM(D22:D33)","v":1000000.0000000003},21.074815595363546,{"$f":"SUM(F22:F33)","v":280000},{"$f":"SUM(G22:G33)","v":351130},{"$f":"SUM(H22:H33)","v":70226},{"$f":"AVERAGE(I22:I33)","v":1},{"$f":"AVERAGE(J22:J33)","v":78},{"$f":"SUM(K22:K33)","v":690260.4055951843},24.24518460116559,{"$f":"SUM(M22:M33)","v":193272.91356665164},{"$f":"SUM(N22:N33)","v":210678.00000000003},{"$f":"SUM(O22:O33)","v":42135.6},{"$f":"AVERAGE(P22:P33)","v":1},-309739.59440481605]
[{"$nulls":4},{"$f":"E34*B34","v":7692.3076923076942},"Forecast annual yield per cow in milk",{"$nulls":5},{"$f":"L34*B34","v":8849.492379425441},"Forecast annual yield per cow in milk"]
[]
[{"$f":"EOMONTH(A33,1)","v":"2021-04-30"},{"$f":"DAY(A37)","v":30},{"$f":"'Hidden calculation original'!S29+'Hidden calculation original'!AJ29","v":130},{"$f":"'Hidden calculation original'!AV29*Output!I37*B37","v":82191.780821917826},{"$f":"IF(C37=0,0,D37/$B37/C37)","v":21.074815595363546},{"$f":"D37*'Calving input'!E44/100","v":23013.698630136991},{"$f":"C37*'Calving input'!G44*B37","v":28860},{"$f":"G37*'Calving input'!F44","v":5772},1,{"$f":"'Hidden calculation alter'!S29+'Hidden calculation alter'!AJ29","v":78},{"$f":"'Hidden calculation alter'!AV29*P37*B37","v":56733.731966727479},{"$f":"IF(J37=0,0,K37/B37/J37)","v":24.24518460116559},{"$f":"K37*'Calving input'!J44/100","v":15885.444950683694},{"$f":"J37*'Calving input'!L44*B37","v":17316},{"$f":"N37*'Calving input'!K44","v":3463.2000000000003},1,{"$f":"K37-D37","v":-25458.048855190347}]
[{"$f":"EOMONTH(A37,1)","v":"2021-05-31"},{"$f":"DAY(A38)","v":31},{"$f":"'Hidden calculation original'!S30+'Hidden calculation original'!AJ30","v":130},{"$f":"'Hidden calculation original'!AV30*Output!I38*B38","v":84931.50684931509},{"$f":"IF(C38=0,0,D38/$B38/C38)","v":21.074815595363546},{"$f":"D38*'Calving input'!E45/100","v":23780.821917808222},{"$f":"C38*'Calving input'!G45*B38","v":29822},{"$f":"G38*'Calving input'!F45","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S30+'Hidden calculation alter'!AJ30","v":78},{"$f":"'Hidden calculation alter'!AV30*P38*B38","v":58624.856365618391},24.24518460116559,{"$f":"K38*'Calving input'!J45/100","v":16414.959782373149},{"$f":"J38*'Calving input'!L45*B38","v":17893.2},{"$f":"N38*'Calving input'!K45","v":3578.6400000000003},1,-26306.6504836967]
["2021-06-30",30,{"$f":"'Hidden calculation original'!S31+'Hidden calculation original'!AJ31","v":130},{"$f":"'Hidden calculation original'!AV31*Output!I39*B39","v":82191.780821917826},21.074815595363546,{"$f":"D39*'Calving input'!E46/100","v":23013.698630136991},{"$f":"C39*'Calving input'!G46*B39","v":28860},{"$f":"G39*'Calving input'!F46","v":5772},1,{"$f":"'Hidden calculation alter'!S31+'Hidden calculation alter'!AJ31","v":78},{"$f":"'Hidden calculation alter'!AV31*P39*B39","v":56733.731966727479},24.24518460116559,{"$f":"K39*'Calving input'!J46/100","v":15885.444950683694},{"$f":"J39*'Calving input'!L46*B39","v":17316},{"$f":"N39*'Calving input'!K46","v":3463.2000000000003},1,-25458.048855190347]
["2021-07-31",31,{"$f":"'Hidden calculation original'!S32+'Hidden calculation original'!AJ32","v":130},{"$f":"'Hidden calculation original'!AV32*Output!I40*B40","v":84931.50684931509},21.074815595363546,{"$f":"D40*'Calving input'!E47/100","v":23780.821917808222},{"$f":"C40*'Calving input'!G47*B40","v":29822},{"$f":"G40*'Calving input'!F47","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S32+'Hidden calculation alter'!AJ32","v":78},{"$f":"'Hidden calculation alter'!AV32*P40*B40","v":58624.856365618391},24.24518460116559,{"$f":"K40*'Calving input'!J47/100","v":16414.959782373149},{"$f":"J40*'Calving input'!L47*B40","v":17893.2},{"$f":"N40*'Calving input'!K47","v":3578.6400000000003},1,-26306.6504836967]
["2021-08-31",31,{"$f":"'Hidden calculation original'!S33+'Hidden calculation original'!AJ33","v":130},{"$f":"'Hidden calculation original'!AV33*Output!I41*B41","v":84931.50684931509},21.074815595363546,{"$f":"D41*'Calving input'!E48/100","v":23780.821917808222},{"$f":"C41*'Calving input'!G48*B41","v":29822},{"$f":"G41*'Calving input'!F48","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S33+'Hidden calculation alter'!AJ33","v":78},{"$f":"'Hidden calculation alter'!AV33*P41*B41","v":58624.856365618391},24.24518460116559,{"$f":"K41*'Calving input'!J48/100","v":16414.959782373149},{"$f":"J41*'Calving input'!L48*B41","v":17893.2},{"$f":"N41*'Calving input'!K48","v":3578.6400000000003},1,-26306.6504836967]
["2021-09-30",30,{"$f":"'Hidden calculation original'!S34+'Hidden calculation original'!AJ34","v":130},{"$f":"'Hidden calculation original'!AV34*Output!I42*B42","v":82191.780821917826},21.074815595363546,{"$f":"D42*'Calving input'!E49/100","v":23013.698630136991},{"$f":"C42*'Calving input'!G49*B42","v":28860},{"$f":"G42*'Calving input'!F49","v":5772},1,{"$f":"'Hidden calculation alter'!S34+'Hidden calculation alter'!AJ34","v":78},{"$f":"'Hidden calculation alter'!AV34*P42*B42","v":56733.731966727479},24.24518460116559,{"$f":"K42*'Calving input'!J49/100","v":15885.444950683694},{"$f":"J42*'Calving input'!L49*B42","v":17316},{"$f":"N42*'Calving input'!K49","v":3463.2000000000003},1,-25458.048855190347]
["2021-10-31",31,{"$f":"'Hidden calculation original'!S35+'Hidden calculation original'!AJ35","v":130},{"$f":"'Hidden calculation original'!AV35*Output!I43*B43","v":84931.50684931509},21.074815595363546,{"$f":"D43*'Calving input'!E50/100","v":23780.821917808222},{"$f":"C43*'Calving input'!G50*B43","v":29822},{"$f":"G43*'Calving input'!F50","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S35+'Hidden calculation alter'!AJ35","v":78},{"$f":"'Hidden calculation alter'!AV35*P43*B43","v":58624.856365618391},24.24518460116559,{"$f":"K43*'Calving input'!J50/100","v":16414.959782373149},{"$f":"J43*'Calving input'!L50*B43","v":17893.2},{"$f":"N43*'Calving input'!K50","v":3578.6400000000003},1,-26306.6504836967]
["2021-11-30",30,{"$f":"'Hidden calculation original'!S36+'Hidden calculation original'!AJ36","v":130},{"$f":"'Hidden calculation original'!AV36*Output!I44*B44","v":82191.780821917826},21.074815595363546,{"$f":"D44*'Calving input'!E51/100","v":23013.698630136991},{"$f":"C44*'Calving input'!G51*B44","v":28860},{"$f":"G44*'Calving input'!F51","v":5772},1,{"$f":"'Hidden calculation alter'!S36+'Hidden calculation alter'!AJ36","v":78},{"$f":"'Hidden calculation alter'!AV36*P44*B44","v":56733.731966727479},24.24518460116559,{"$f":"K44*'Calving input'!J51/100","v":15885.444950683694},{"$f":"J44*'Calving input'!L51*B44","v":17316},{"$f":"N44*'Calving input'!K51","v":3463.2000000000003},1,-25458.048855190347]
["2021-12-31",31,{"$f":"'Hidden calculation original'!S37+'Hidden calculation original'!AJ37","v":130},{"$f":"'Hidden calculation original'!AV37*Output!I45*B45","v":84931.50684931509},21.074815595363546,{"$f":"D45*'Calving input'!E52/100","v":23780.821917808222},{"$f":"C45*'Calving input'!G52*B45","v":29822},{"$f":"G45*'Calving input'!F52","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S37+'Hidden calculation alter'!AJ37","v":78},{"$f":"'Hidden calculation alter'!AV37*P45*B45","v":58624.856365618391},24.24518460116559,{"$f":"K45*'Calving input'!J52/100","v":16414.959782373149},{"$f":"J45*'Calving input'!L52*B45","v":17893.2},{"$f":"N45*'Calving input'!K52","v":3578.6400000000003},1,-26306.6504836967]
["2022-01-31",31,{"$f":"'Hidden calculation original'!S38+'Hidden calculation original'!AJ38","v":130},{"$f":"'Hidden calculation original'!AV38*Output!I46*B46","v":84931.50684931509},21.074815595363546,{"$f":"D46*'Calving input'!E53/100","v":23780.821917808222},{"$f":"C46*'Calving input'!G53*B46","v":29822},{"$f":"G46*'Calving input'!F53","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S38+'Hidden calculation alter'!AJ38","v":78},{"$f":"'Hidden calculation alter'!AV38*P46*B46","v":58624.856365618391},24.24518460116559,{"$f":"K46*'Calving input'!J53/100","v":16414.959782373149},{"$f":"J46*'Calving input'!L53*B46","v":17893.2},{"$f":"N46*'Calving input'!K53","v":3578.6400000000003},1,-26306.6504836967]
["2022-02-28",28,{"$f":"'Hidden calculation original'!S39+'Hidden calculation original'!AJ39","v":130},{"$f":"'Hidden calculation original'!AV39*Output!I47*B47","v":76712.328767123312},21.074815595363546,{"$f":"D47*'Calving input'!E54/100","v":21479.452054794529},{"$f":"C47*'Calving input'!G54*B47","v":26936},{"$f":"G47*'Calving input'!F54","v":5387.2000000000007},1,{"$f":"'Hidden calculation alter'!S39+'Hidden calculation alter'!AJ39","v":78},{"$f":"'Hidden calculation alter'!AV39*P47*B47","v":52951.483168945648},24.24518460116559,{"$f":"K47*'Calving input'!J54/100","v":14826.415287304781},{"$f":"J47*'Calving input'!L54*B47","v":16161.600000000002},{"$f":"N47*'Calving input'!K54","v":3232.3200000000006},1,-23760.845598177664]
["2022-03-31",31,{"$f":"'Hidden calculation original'!S40+'Hidden calculation original'!AJ40","v":130},{"$f":"'Hidden calculation original'!AV40*Output!I48*B48","v":84931.50684931509},21.074815595363546,{"$f":"D48*'Calving input'!E55/100","v":23780.821917808222},{"$f":"C48*'Calving input'!G55*B48","v":29822},{"$f":"G48*'Calving input'!F55","v":5964.4000000000005},1,{"$f":"'Hidden calculation alter'!S40+'Hidden calculation alter'!AJ40","v":78},{"$f":"'Hidden calculation alter'!AV40*P48*B48","v":58624.856365618391},24.24518460116559,{"$f":"K48*'Calving input'!J55/100","v":16414.959782373149},{"$f":"J48*'Calving input'!L55*B48","v":17893.2},{"$f":"N48*'Calving input'!K55","v":3578.6400000000003},1,-26306.6504836967]
["Year 3",{"$f":"SUM(B37:B48)","v":365},{"$f":"AVERAGE(C37:C48)","v":130},{"$f":"SUM(D37:D48)","v":1000000.0000000003},21.074815595363546,{"$f":"SUM(F37:F48)","v":280000},{"$f":"SUM(G37:G48)","v":351130},{"$f":"SUM(H37:H48)","v":70226},{"$f":"AVERAGE(I37:I48)","v":1},{"$f":"AVERAGE(J37:J48)","v":78},{"$f":"SUM(K37:K48)","v":690260.4055951843},24.24518460116559,{"$f":"SUM(M37:M48)","v":193272.91356665164},{"$f":"SUM(N37:N48)","v":210678.00000000003},{"$f":"SUM(O37:O48)","v":42135.6},{"$f":"AVERAGE(P37:P48)","v":1},-309739.59440481605]
[{"$nulls":4},{"$f":"E49*B49","v":7692.3076923076942},"Forecast annual yield per cow in milk",{"$nulls":5},{"$f":"L49*B49","v":8849.492379425441},"Forecast annual yield per cow in milk"]

{"sheet":"Output charts","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Milk Forecasting Calculator Outputs"]

{"sheet":"Outputs for chart","index":6,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[null,null,"Current scenario","Alternative scenario","Current scenario","Alternative scenario","Current scenario","Alternative scenario","Current scenario","Alternative scenario","Current scenario","Alternative scenario","Current scenario","Alternative scenario"]
[null,null,"Total milk produced (litres)","Total milk produced (litres)","Daily production","Daily production","Daily yield per cow in milk (litres)","Daily yield per cow in milk (litres)","Total Milk Value (£)","Total Milk Value (£)","Feed costs (£)","Feed costs (£)","Margin over feed (£)","Margin over feed (£)"]
[{"$f":"Output!A7","v":"2019-04-30"},{"$f":"DAY(A3)","v":30},{"$f":"Output!D7","v":82191.780821917826},{"$f":"Output!K7","v":56733.731966727479},{"$f":"C3/$B3","v":2739.7260273972611},{"$f":"D3/$B3","v":1891.1243988909159},{"$f":"Output!E7","v":21.074815595363546},{"$f":"Output!L7","v":24.24518460116559},{"$f":"Output!F7","v":23013.698630136991},{"$f":"Output!M7","v":15885.444950683694},{"$f":"Output!H7","v":5772},{"$f":"Output!O7","v":3463.2000000000003},{"$f":"I3-K3","v":17241.698630136991},{"$f":"J3-L3","v":12422.244950683693}]
[{"$f":"Output!A8","v":"2019-05-31"},{"$f":"DAY(A4)","v":31},{"$f":"Output!D8","v":84931.50684931509},{"$f":"Output!K8","v":58624.856365618391},{"$f":"C4/$B4","v":2739.7260273972611},1891.1243988909159,{"$f":"Output!E8","v":21.074815595363546},{"$f":"Output!L8","v":24.24518460116559},{"$f":"Output!F8","v":23780.821917808222},{"$f":"Output!M8","v":16414.959782373149},{"$f":"Output!H8","v":5964.4000000000005},{"$f":"Output!O8","v":3578.6400000000003},{"$f":"I4-K4","v":17816.42191780822},{"$f":"J4-L4","v":12836.31978237315}]
[{"$f":"Output!A9","v":"2019-06-30"},30,{"$f":"Output!D9","v":82191.780821917826},{"$f":"Output!K9","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E9","v":21.074815595363546},{"$f":"Output!L9","v":24.24518460116559},{"$f":"Output!F9","v":23013.698630136991},{"$f":"Output!M9","v":15885.444950683694},{"$f":"Output!H9","v":5772},{"$f":"Output!O9","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A10","v":"2019-07-31"},31,{"$f":"Output!D10","v":84931.50684931509},{"$f":"Output!K10","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E10","v":21.074815595363546},{"$f":"Output!L10","v":24.24518460116559},{"$f":"Output!F10","v":23780.821917808222},{"$f":"Output!M10","v":16414.959782373149},{"$f":"Output!H10","v":5964.4000000000005},{"$f":"Output!O10","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A11","v":"2019-08-31"},31,{"$f":"Output!D11","v":84931.50684931509},{"$f":"Output!K11","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E11","v":21.074815595363546},{"$f":"Output!L11","v":24.24518460116559},{"$f":"Output!F11","v":23780.821917808222},{"$f":"Output!M11","v":16414.959782373149},{"$f":"Output!H11","v":5964.4000000000005},{"$f":"Output!O11","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A12","v":"2019-09-30"},30,{"$f":"Output!D12","v":82191.780821917826},{"$f":"Output!K12","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E12","v":21.074815595363546},{"$f":"Output!L12","v":24.24518460116559},{"$f":"Output!F12","v":23013.698630136991},{"$f":"Output!M12","v":15885.444950683694},{"$f":"Output!H12","v":5772},{"$f":"Output!O12","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A13","v":"2019-10-31"},31,{"$f":"Output!D13","v":84931.50684931509},{"$f":"Output!K13","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E13","v":21.074815595363546},{"$f":"Output!L13","v":24.24518460116559},{"$f":"Output!F13","v":23780.821917808222},{"$f":"Output!M13","v":16414.959782373149},{"$f":"Output!H13","v":5964.4000000000005},{"$f":"Output!O13","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A14","v":"2019-11-30"},30,{"$f":"Output!D14","v":82191.780821917826},{"$f":"Output!K14","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E14","v":21.074815595363546},{"$f":"Output!L14","v":24.24518460116559},{"$f":"Output!F14","v":23013.698630136991},{"$f":"Output!M14","v":15885.444950683694},{"$f":"Output!H14","v":5772},{"$f":"Output!O14","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A15","v":"2019-12-31"},31,{"$f":"Output!D15","v":84931.50684931509},{"$f":"Output!K15","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E15","v":21.074815595363546},{"$f":"Output!L15","v":24.24518460116559},{"$f":"Output!F15","v":23780.821917808222},{"$f":"Output!M15","v":16414.959782373149},{"$f":"Output!H15","v":5964.4000000000005},{"$f":"Output!O15","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A16","v":"2020-01-31"},31,{"$f":"Output!D16","v":84931.50684931509},{"$f":"Output!K16","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E16","v":21.074815595363546},{"$f":"Output!L16","v":24.24518460116559},{"$f":"Output!F16","v":23780.821917808222},{"$f":"Output!M16","v":16414.959782373149},{"$f":"Output!H16","v":5964.4000000000005},{"$f":"Output!O16","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A17","v":"2020-02-29"},29,{"$f":"Output!D17","v":79452.054794520576},{"$f":"Output!K17","v":54842.60756783656},2739.7260273972611,1891.1243988909159,{"$f":"Output!E17","v":21.074815595363546},{"$f":"Output!L17","v":24.24518460116559},{"$f":"Output!F17","v":22246.57534246576},{"$f":"Output!M17","v":15355.930118994238},{"$f":"Output!H17","v":5579.6},{"$f":"Output!O17","v":3347.7600000000007},16666.975342465761,12008.170118994238]
[{"$f":"Output!A18","v":"2020-03-31"},31,{"$f":"Output!D18","v":84931.50684931509},{"$f":"Output!K18","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E18","v":21.074815595363546},{"$f":"Output!L18","v":24.24518460116559},{"$f":"Output!F18","v":23780.821917808222},{"$f":"Output!M18","v":16414.959782373149},{"$f":"Output!H18","v":5964.4000000000005},{"$f":"Output!O18","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A22","v":"2020-04-30"},30,{"$f":"Output!D22","v":82191.780821917826},{"$f":"Output!K22","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E22","v":21.074815595363546},{"$f":"Output!L22","v":24.24518460116559},{"$f":"Output!F22","v":23013.698630136991},{"$f":"Output!M22","v":15885.444950683694},{"$f":"Output!H22","v":5772},{"$f":"Output!O22","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A23","v":"2020-05-31"},31,{"$f":"Output!D23","v":84931.50684931509},{"$f":"Output!K23","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E23","v":21.074815595363546},{"$f":"Output!L23","v":24.24518460116559},{"$f":"Output!F23","v":23780.821917808222},{"$f":"Output!M23","v":16414.959782373149},{"$f":"Output!H23","v":5964.4000000000005},{"$f":"Output!O23","v":3578.6400000000003},{"$f":"I16-K16","v":17816.42191780822},{"$f":"J16-L16","v":12836.31978237315}]
[{"$f":"Output!A24","v":"2020-06-30"},30,{"$f":"Output!D24","v":82191.780821917826},{"$f":"Output!K24","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E24","v":21.074815595363546},{"$f":"Output!L24","v":24.24518460116559},{"$f":"Output!F24","v":23013.698630136991},{"$f":"Output!M24","v":15885.444950683694},{"$f":"Output!H24","v":5772},{"$f":"Output!O24","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A25","v":"2020-07-31"},31,{"$f":"Output!D25","v":84931.50684931509},{"$f":"Output!K25","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E25","v":21.074815595363546},{"$f":"Output!L25","v":24.24518460116559},{"$f":"Output!F25","v":23780.821917808222},{"$f":"Output!M25","v":16414.959782373149},{"$f":"Output!H25","v":5964.4000000000005},{"$f":"Output!O25","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A26","v":"2020-08-31"},31,{"$f":"Output!D26","v":84931.50684931509},{"$f":"Output!K26","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E26","v":21.074815595363546},{"$f":"Output!L26","v":24.24518460116559},{"$f":"Output!F26","v":23780.821917808222},{"$f":"Output!M26","v":16414.959782373149},{"$f":"Output!H26","v":5964.4000000000005},{"$f":"Output!O26","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A27","v":"2020-09-30"},30,{"$f":"Output!D27","v":82191.780821917826},{"$f":"Output!K27","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E27","v":21.074815595363546},{"$f":"Output!L27","v":24.24518460116559},{"$f":"Output!F27","v":23013.698630136991},{"$f":"Output!M27","v":15885.444950683694},{"$f":"Output!H27","v":5772},{"$f":"Output!O27","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A28","v":"2020-10-31"},31,{"$f":"Output!D28","v":84931.50684931509},{"$f":"Output!K28","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E28","v":21.074815595363546},{"$f":"Output!L28","v":24.24518460116559},{"$f":"Output!F28","v":23780.821917808222},{"$f":"Output!M28","v":16414.959782373149},{"$f":"Output!H28","v":5964.4000000000005},{"$f":"Output!O28","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A29","v":"2020-11-30"},30,{"$f":"Output!D29","v":82191.780821917826},{"$f":"Output!K29","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E29","v":21.074815595363546},{"$f":"Output!L29","v":24.24518460116559},{"$f":"Output!F29","v":23013.698630136991},{"$f":"Output!M29","v":15885.444950683694},{"$f":"Output!H29","v":5772},{"$f":"Output!O29","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A30","v":"2020-12-31"},31,{"$f":"Output!D30","v":84931.50684931509},{"$f":"Output!K30","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E30","v":21.074815595363546},{"$f":"Output!L30","v":24.24518460116559},{"$f":"Output!F30","v":23780.821917808222},{"$f":"Output!M30","v":16414.959782373149},{"$f":"Output!H30","v":5964.4000000000005},{"$f":"Output!O30","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A31","v":"2021-01-31"},31,{"$f":"Output!D31","v":84931.50684931509},{"$f":"Output!K31","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E31","v":21.074815595363546},{"$f":"Output!L31","v":24.24518460116559},{"$f":"Output!F31","v":23780.821917808222},{"$f":"Output!M31","v":16414.959782373149},{"$f":"Output!H31","v":5964.4000000000005},{"$f":"Output!O31","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A32","v":"2021-02-28"},28,{"$f":"Output!D32","v":76712.328767123312},{"$f":"Output!K32","v":52951.483168945648},2739.7260273972611,1891.1243988909159,{"$f":"Output!E32","v":21.074815595363546},{"$f":"Output!L32","v":24.24518460116559},{"$f":"Output!F32","v":21479.452054794529},{"$f":"Output!M32","v":14826.415287304781},{"$f":"Output!H32","v":5387.2000000000007},{"$f":"Output!O32","v":3232.3200000000006},16092.252054794528,11594.095287304779]
[{"$f":"Output!A33","v":"2021-03-31"},31,{"$f":"Output!D33","v":84931.50684931509},{"$f":"Output!K33","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E33","v":21.074815595363546},{"$f":"Output!L33","v":24.24518460116559},{"$f":"Output!F33","v":23780.821917808222},{"$f":"Output!M33","v":16414.959782373149},{"$f":"Output!H33","v":5964.4000000000005},{"$f":"Output!O33","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A37","v":"2021-04-30"},30,{"$f":"Output!D37","v":82191.780821917826},{"$f":"Output!K37","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E37","v":21.074815595363546},{"$f":"Output!L37","v":24.24518460116559},{"$f":"Output!F37","v":23013.698630136991},{"$f":"Output!M37","v":15885.444950683694},{"$f":"Output!H37","v":5772},{"$f":"Output!O37","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A38","v":"2021-05-31"},31,{"$f":"Output!D38","v":84931.50684931509},{"$f":"Output!K38","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E38","v":21.074815595363546},{"$f":"Output!L38","v":24.24518460116559},{"$f":"Output!F38","v":23780.821917808222},{"$f":"Output!M38","v":16414.959782373149},{"$f":"Output!H38","v":5964.4000000000005},{"$f":"Output!O38","v":3578.6400000000003},{"$f":"I28-K28","v":17816.42191780822},{"$f":"J28-L28","v":12836.31978237315}]
[{"$f":"Output!A39","v":"2021-06-30"},30,{"$f":"Output!D39","v":82191.780821917826},{"$f":"Output!K39","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E39","v":21.074815595363546},{"$f":"Output!L39","v":24.24518460116559},{"$f":"Output!F39","v":23013.698630136991},{"$f":"Output!M39","v":15885.444950683694},{"$f":"Output!H39","v":5772},{"$f":"Output!O39","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A40","v":"2021-07-31"},31,{"$f":"Output!D40","v":84931.50684931509},{"$f":"Output!K40","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E40","v":21.074815595363546},{"$f":"Output!L40","v":24.24518460116559},{"$f":"Output!F40","v":23780.821917808222},{"$f":"Output!M40","v":16414.959782373149},{"$f":"Output!H40","v":5964.4000000000005},{"$f":"Output!O40","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A41","v":"2021-08-31"},31,{"$f":"Output!D41","v":84931.50684931509},{"$f":"Output!K41","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E41","v":21.074815595363546},{"$f":"Output!L41","v":24.24518460116559},{"$f":"Output!F41","v":23780.821917808222},{"$f":"Output!M41","v":16414.959782373149},{"$f":"Output!H41","v":5964.4000000000005},{"$f":"Output!O41","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A42","v":"2021-09-30"},30,{"$f":"Output!D42","v":82191.780821917826},{"$f":"Output!K42","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E42","v":21.074815595363546},{"$f":"Output!L42","v":24.24518460116559},{"$f":"Output!F42","v":23013.698630136991},{"$f":"Output!M42","v":15885.444950683694},{"$f":"Output!H42","v":5772},{"$f":"Output!O42","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A43","v":"2021-10-31"},31,{"$f":"Output!D43","v":84931.50684931509},{"$f":"Output!K43","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E43","v":21.074815595363546},{"$f":"Output!L43","v":24.24518460116559},{"$f":"Output!F43","v":23780.821917808222},{"$f":"Output!M43","v":16414.959782373149},{"$f":"Output!H43","v":5964.4000000000005},{"$f":"Output!O43","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A44","v":"2021-11-30"},30,{"$f":"Output!D44","v":82191.780821917826},{"$f":"Output!K44","v":56733.731966727479},2739.7260273972611,1891.1243988909159,{"$f":"Output!E44","v":21.074815595363546},{"$f":"Output!L44","v":24.24518460116559},{"$f":"Output!F44","v":23013.698630136991},{"$f":"Output!M44","v":15885.444950683694},{"$f":"Output!H44","v":5772},{"$f":"Output!O44","v":3463.2000000000003},17241.698630136991,12422.244950683693]
[{"$f":"Output!A45","v":"2021-12-31"},31,{"$f":"Output!D45","v":84931.50684931509},{"$f":"Output!K45","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E45","v":21.074815595363546},{"$f":"Output!L45","v":24.24518460116559},{"$f":"Output!F45","v":23780.821917808222},{"$f":"Output!M45","v":16414.959782373149},{"$f":"Output!H45","v":5964.4000000000005},{"$f":"Output!O45","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A46","v":"2022-01-31"},31,{"$f":"Output!D46","v":84931.50684931509},{"$f":"Output!K46","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E46","v":21.074815595363546},{"$f":"Output!L46","v":24.24518460116559},{"$f":"Output!F46","v":23780.821917808222},{"$f":"Output!M46","v":16414.959782373149},{"$f":"Output!H46","v":5964.4000000000005},{"$f":"Output!O46","v":3578.6400000000003},17816.42191780822,12836.31978237315]
[{"$f":"Output!A47","v":"2022-02-28"},28,{"$f":"Output!D47","v":76712.328767123312},{"$f":"Output!K47","v":52951.483168945648},2739.7260273972611,1891.1243988909159,{"$f":"Output!E47","v":21.074815595363546},{"$f":"Output!L47","v":24.24518460116559},{"$f":"Output!F47","v":21479.452054794529},{"$f":"Output!M47","v":14826.415287304781},{"$f":"Output!H47","v":5387.2000000000007},{"$f":"Output!O47","v":3232.3200000000006},16092.252054794528,11594.095287304779]
[{"$f":"Output!A48","v":"2022-03-31"},31,{"$f":"Output!D48","v":84931.50684931509},{"$f":"Output!K48","v":58624.856365618391},2739.7260273972611,1891.1243988909159,{"$f":"Output!E48","v":21.074815595363546},{"$f":"Output!L48","v":24.24518460116559},{"$f":"Output!F48","v":23780.821917808222},{"$f":"Output!M48","v":16414.959782373149},{"$f":"Output!H48","v":5964.4000000000005},{"$f":"Output!O48","v":3578.6400000000003},17816.42191780822,12836.31978237315]

{"sheet":"Hidden calculation original","index":7,"n_rows":58,"n_cols":53,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Targets given",null,null,"Days",30,61,91,122,152,183,213,244,274,305,335,365,395,425]
[null,"start yield",null,"Retention",{"$f":"'Culling rate'!F5","v":1},{"$f":"IF(Input!$F$12-Input!F13>=F1,'Culling rate'!F6,IF(Input!$F$12-Input!F13<E1,0,(Input!$F$12-Input!F13-E1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=G1,'Culling rate'!F7,IF(Input!$F$12-Input!F13<F1,0,(Input!$F$12-Input!F13-F1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=H1,'Culling rate'!F8,IF(Input!$F$12-Input!F13<G1,0,(Input!$F$12-Input!F13-G1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=I1,'Culling rate'!F9,IF(Input!$F$12-Input!F13<H1,0,(Input!$F$12-Input!F13-H1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=J1,'Culling rate'!F10,IF(Input!$F$12-Input!F13<I1,0,(Input!$F$12-Input!F13-I1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=K1,'Culling rate'!F11,IF(Input!$F$12-Input!F13<J1,0,(Input!$F$12-Input!F13-J1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=L1,'Culling rate'!F12,IF(Input!$F$12-Input!F13<K1,0,(Input!$F$12-Input!F13-K1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=M1,'Culling rate'!F13,IF(Input!$F$12-Input!F13<L1,0,(Input!$F$12-Input!F13-L1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=N1,'Culling rate'!F14,IF(Input!$F$12-Input!F13<M1,0,(Input!$F$12-Input!F13-M1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=O1,'Culling rate'!F15,IF(Input!$F$12-Input!F13<N1,0,(Input!$F$12-Input!F13-N1)/30))","v":0},{"$f":"IF(Input!$F$12-Input!F13>=P1,'Culling rate'!F16,IF(Input!$F$12-Input!F13<O1,0,(Input!$F$12-Input!F13-O1)/30))","v":0},{"$f":"IF(Input!$F$12-Input!F13>=Q1,'Culling rate'!F17,IF(Input!$F$12-Input!F13<P1,0,(Input!$F$12-Input!F13-P1)/30))","v":0},{"$f":"IF(Input!$F$12-Input!F13>=R1,'Culling rate'!F18,IF(Input!$F$12-Input!F13<Q1,0,(Input!$F$12-Input!F13-Q1)/30))","v":0},null,null,"Retention",{"$f":"'Culling rate'!G5","v":1},{"$f":"IF(Input!$F$12-Input!F13>=F1,'Culling rate'!G6,IF(Input!$F$12-Input!F13<E1,0,(Input!$F$12-Input!F13-E1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=G1,'Culling rate'!$G7,IF(Input!$F$12-Input!F13<F1,0,(Input!$F$12-Input!F13-F1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=H1,'Culling rate'!$G8,IF(Input!$F$12-Input!F13<G1,0,(Input!$F$12-Input!F13-G1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=I1,'Culling rate'!$G9,IF(Input!$F$12-Input!F13<H1,0,(Input!$F$12-Input!F13-H1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=J1,'Culling rate'!$G10,IF(Input!$F$12-Input!F13<I1,0,(Input!$F$12-Input!F13-I1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=K1,'Culling rate'!$G11,IF(Input!$F$12-Input!F13<J1,0,(Input!$F$12-Input!F13-J1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=L1,'Culling rate'!$G12,IF(Input!$F$12-Input!F13<K1,0,(Input!$F$12-Input!F13-K1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=M1,'Culling rate'!$G13,IF(Input!$F$12-Input!F13<L1,0,(Input!$F$12-Input!F13-L1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=N1,'Culling rate'!$G14,IF(Input!$F$12-Input!F13<M1,0,(Input!$F$12-Input!F13-M1)/30))","v":1},{"$f":"IF(Input!$F$12-Input!F13>=O1,'Culling rate'!$G15,IF(Input!$F$12-Input!F13<N1,0,(Input!$F$12-Input!F13-N1)/30))","v":0},{"$f":"IF(Input!$F$12-Input!F13>=P1,'Culling rate'!$G16,IF(Input!$F$12-Input!F13<O1,0,(Input!$F$12-Input!F13-O1)/30))","v":0},{"$f":"IF(Input!$F$12-Input!F13>=Q1,'Culling rate'!$G17,IF(Input!$F$12-Input!F13<P1,0,(Input!$F$12-Input!F13-P1)/30))","v":0},{"$f":"IF(Input!$F$12-Input!F13>=R1,'Culling rate'!$G18,IF(Input!$F$12-Input!F13<Q1,0,(Input!$F$12-Input!F13-Q1)/30))","v":0},null,null,null,"Used lookup",{"$f":"IF(Input!$F$14='Hidden calculation original'!AN4,1,0)","v":1},{"$f":"IF(Input!$F$14='Hidden calculation original'!AO4,1,0)","v":0},{"$f":"IF(Input!$F$14='Hidden calculation original'!AP4,1,0)","v":0},{"$f":"IF(Input!$F$14='Hidden calculation original'!AQ4,1,0)","v":0},{"$f":"IF(Input!$F$14='Hidden calculation original'!AR4,1,0)","v":0},{"$f":"IF(Input!$F$14='Hidden calculation original'!AS4,1,0)","v":0},{"$f":"IF(Input!$F$14='Hidden calculation original'!AT4,1,0)","v":0},{"$f":"IF(Input!$F$14='Hidden calculation original'!AU4,1,0)","v":0}]
["yield target ",{"$f":"Input!F18","v":7692.3076923076924},null,"Heifers","Lactation",{"$nulls":15},"Cows","Lactation",{"$nulls":17},1,2,3,4,5,6,7,8]
["Heifer yield as % of cows yield",{"$f":"Input!F15*100","v":85},null,"Month production",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Heifers-in-milk",null,"Month production",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Cows-in-milk",null,null,"Month production","Feed to yield","Step rate","Flat rate","Total mixed ration","Three times a day milking","Once a day milking","Spring block","Autumn block","Yield used","Yield per month","Yield for cows","Yield for heifers"]
["No cows",{"$f":"'Calving input'!D17","v":120},null,1,{"$f":"'Calving input'!C$16/2+'Calving input'!C$18/2","v":3},{"$f":"'Calving input'!C$15/2+'Calving input'!C$16/2","v":3},{"$f":"'Calving input'!C$14/2+'Calving input'!C$15/2","v":3},{"$f":"'Calving input'!C$13/2+'Calving input'!C$14/2","v":3},{"$f":"'Calving input'!C$12/2+'Calving input'!C$13/2","v":3},{"$f":"'Calving input'!C$11/2+'Calving input'!C$12/2","v":3},{"$f":"'Calving input'!C$10/2+'Calving input'!C$11/2","v":3},{"$f":"'Calving input'!C$9/2+'Calving input'!C$10/2","v":3},{"$f":"'Calving input'!C$8/2+'Calving input'!C$9/2","v":3},{"$f":"'Calving input'!C$7/2+'Calving input'!C$8/2","v":3},{"$f":"'Calving input'!C$6/2+'Calving input'!C$7/2","v":3},{"$f":"'Calving input'!C$5/2+'Calving input'!C$6/2","v":3},{"$f":"'Calving input'!C$16/2+'Calving input'!C$5/2","v":3},{"$f":"'Calving input'!C$15/2+'Calving input'!C$16/2","v":3},{"$f":"ROUND(SUMPRODUCT(E5:R5,$E$2:$R$2),0)","v":30},null,1,{"$f":"'Calving input'!D$16/2+'Calving input'!D$18/2","v":10},{"$f":"'Calving input'!D$15/2+'Calving input'!D$16/2","v":10},{"$f":"'Calving input'!D$14/2+'Calving input'!D$15/2","v":10},{"$f":"'Calving input'!D$13/2+'Calving input'!D$14/2","v":10},{"$f":"'Calving input'!D$12/2+'Calving input'!D$13/2","v":10},{"$f":"'Calving input'!D$11/2+'Calving input'!D$12/2","v":10},{"$f":"'Calving input'!D$10/2+'Calving input'!D$11/2","v":10},{"$f":"'Calving input'!D$9/2+'Calving input'!D$10/2","v":10},{"$f":"'Calving input'!D$8/2+'Calving input'!D$9/2","v":10},{"$f":"'Calving input'!D$7/2+'Calving input'!D$8/2","v":10},{"$f":"'Calving input'!D$6/2+'Calving input'!D$7/2","v":10},{"$f":"'Calving input'!D$5/2+'Calving input'!D$6/2","v":10},{"$f":"'Calving input'!D$16/2+'Calving input'!D$5/2","v":10},{"$f":"'Calving input'!D$15/2+'Calving input'!D$16/2","v":10},{"$f":"ROUND(SUMPRODUCT(V5:AI5,$V$2:$AI$2),0)","v":100},null,{"$f":"Input!F9","v":"2019-04-30"},1,{"$f":"(SUMPRODUCT($E$43:$R$43,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$44:$R$44,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972611},{"$f":"(SUMPRODUCT($E$45:$R$45,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$46:$R$46,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972602},{"$f":"(SUMPRODUCT($E$47:$R$47,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$48:$R$48,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972606},{"$f":"(SUMPRODUCT($E$49:$R$49,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$50:$R$50,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972606},{"$f":"(SUMPRODUCT($E$51:$R$51,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$52:$R$52,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972606},{"$f":"(SUMPRODUCT($E$53:$R$53,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$54:$R$54,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972602},{"$f":"(SUMPRODUCT($E$55:$R$55,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$56:$R$56,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.6703596572615},{"$f":"(SUMPRODUCT($E$57:$R$57,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$58:$R$58,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":2739.7260273972597},{"$f":"SUMPRODUCT(AN5:AU5,$AN$2:$AU$2)","v":2739.7260273972611},{"$f":"AV5*DAY(AL5)","v":82191.780821917826},{"$f":"$B$11*(1+$B$17*6.62)","v":7968.1274900398412},{"$f":"$B$12*(1+$B$17*6.62)","v":6772.9083665338649},{"$f":"1000000/365*30","v":82191.780821917811}]
["No heifers",{"$f":"'Calving input'!C17","v":36},null,2,{"$f":"'Calving input'!C18/2+'Calving input'!C19/2","v":3},{"$f":"E5","v":3},{"$f":"F5","v":3},3,3,3,3,3,3,3,3,3,3,3,{"$f":"ROUND(SUMPRODUCT(E6:R6,$E$2:$R$2),0)","v":30},null,2,{"$f":"'Calving input'!D18/2+'Calving input'!D19/2","v":10},{"$f":"V5","v":10},{"$f":"W5","v":10},10,10,10,10,10,10,10,10,10,10,10,{"$f":"ROUND(SUMPRODUCT(V6:AI6,$V$2:$AI$2),0)","v":100},null,{"$f":"EOMONTH(AL5,1)","v":"2019-05-31"},2,{"$f":"(SUMPRODUCT($E$43:$R$43,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$44:$R$44,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972611},{"$f":"(SUMPRODUCT($E$45:$R$45,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$46:$R$46,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972602},{"$f":"(SUMPRODUCT($E$47:$R$47,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$48:$R$48,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972606},{"$f":"(SUMPRODUCT($E$49:$R$49,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$50:$R$50,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972606},{"$f":"(SUMPRODUCT($E$51:$R$51,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$52:$R$52,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972606},{"$f":"(SUMPRODUCT($E$53:$R$53,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$54:$R$54,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972602},{"$f":"(SUMPRODUCT($E$55:$R$55,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$56:$R$56,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.6703596572615},{"$f":"(SUMPRODUCT($E$57:$R$57,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$58:$R$58,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":2739.7260273972597},{"$f":"SUMPRODUCT(AN6:AU6,$AN$2:$AU$2)","v":2739.7260273972611},{"$f":"AV6*DAY(AL6)","v":84931.50684931509},{"$f":"AX5*(1+$B$17)","v":7968.1274900398412},{"$f":"AY5*(1+$B$17)","v":6772.9083665338649},{"$f":"1000000/365*31","v":84931.506849315061}]
["heifers as cow",{"$f":"B6*B4/100","v":30.6},null,3,{"$f":"'Calving input'!C19/2+'Calving input'!C20/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,3,{"$f":"'Calving input'!D19/2+'Calving input'!D20/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,{"$f":"EOMONTH(AL6,1)","v":"2019-06-30"},3,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,{"$f":"AX6*(1+$B$17)","v":7968.1274900398412},{"$f":"AY6*(1+$B$17)","v":6772.9083665338649},{"$f":"1000000/365*30","v":82191.780821917811}]
["equivalents",null,null,4,{"$f":"'Calving input'!C20/2+'Calving input'!C21/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,4,{"$f":"'Calving input'!D20/2+'Calving input'!D21/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2019-07-31",4,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649,{"$f":"1000000/365*31","v":84931.506849315061}]
["Total cow equivalents",{"$f":"B7+B5","v":150.6},null,5,{"$f":"'Calving input'!C21/2+'Calving input'!C22/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,5,{"$f":"'Calving input'!D21/2+'Calving input'!D22/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2019-08-31",5,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
["yield per cow equiv",{"$f":"IF(B9>0,((B5+B6)*B3)/B9,0)","v":7968.1274900398412},null,6,{"$f":"'Calving input'!C22/2+'Calving input'!C23/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,6,{"$f":"'Calving input'!D22/2+'Calving input'!D23/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2019-09-30",6,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
["Cow yield",{"$f":"B10","v":7968.1274900398412},null,7,{"$f":"'Calving input'!C23/2+'Calving input'!C24/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,7,{"$f":"'Calving input'!D23/2+'Calving input'!D24/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2019-10-31",7,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
["Heifer yield",{"$f":"B11*B4/100","v":6772.9083665338649},null,8,{"$f":"'Calving input'!C24/2+'Calving input'!C25/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,8,{"$f":"'Calving input'!D24/2+'Calving input'!D25/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2019-11-30",8,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649,null,{"$f":"(AX7*120+AY7*36)*305/365","v":1002739.7260273972}]
[null,null,null,9,{"$f":"'Calving input'!C25/2+'Calving input'!C26/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,9,{"$f":"'Calving input'!D25/2+'Calving input'!D26/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2019-12-31",9,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
["Av cows-in-milk",{"$f":"SUM($S5:$S16,$AJ5:$AJ16)/12","v":130},null,10,{"$f":"'Calving input'!C26/2+'Calving input'!C27/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,10,{"$f":"'Calving input'!D26/2+'Calving input'!D27/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-01-31",10,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,11,{"$f":"'Calving input'!C27/2+'Calving input'!C28/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,11,{"$f":"'Calving input'!D27/2+'Calving input'!D28/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-02-29",11,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,79452.054794520576,7968.1274900398412,6772.9083665338649]
[null,null,null,12,{"$f":"'Calving input'!C28/2+'Calving input'!C29/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,12,{"$f":"'Calving input'!D28/2+'Calving input'!D29/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-03-31",12,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
["Yield monthly change",{"$f":"IF(Input!F19=0,0,IF(Input!F19<0,Input!F19,NOMINAL(Input!F19,12)))/12","v":0},null,13,{"$f":"'Calving input'!C29/2+'Calving input'!C31/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,13,{"$f":"'Calving input'!D29/2+'Calving input'!D31/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-04-30",13,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,14,{"$f":"'Calving input'!C31/2+'Calving input'!C32/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,14,{"$f":"'Calving input'!D31/2+'Calving input'!D32/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-05-31",14,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
["Yield for charts",null,null,15,{"$f":"'Calving input'!C32/2+'Calving input'!C33/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,15,{"$f":"'Calving input'!D32/2+'Calving input'!D33/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-06-30",15,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
["Cow yield",{"$f":"IF(B11<>0,B11,Input!F18)","v":7968.1274900398412},null,16,{"$f":"'Calving input'!C33/2+'Calving input'!C34/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,16,{"$f":"'Calving input'!D33/2+'Calving input'!D34/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-07-31",16,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
["Heifer yield",{"$f":"IF(B12<>0,B12,Input!F18*Input!F15)","v":6772.9083665338649},null,17,{"$f":"'Calving input'!C34/2+'Calving input'!C35/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,17,{"$f":"'Calving input'!D34/2+'Calving input'!D35/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-08-31",17,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,18,{"$f":"'Calving input'!C35/2+'Calving input'!C36/2","v":3},3,{"$f":"F21","v":3},3,3,3,3,3,3,3,3,3,3,3,30,null,18,{"$f":"'Calving input'!D35/2+'Calving input'!D36/2","v":10},10,{"$f":"W21","v":10},10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-09-30",18,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,19,{"$f":"'Calving input'!C36/2+'Calving input'!C37/2","v":3},{"$f":"E22","v":3},3,3,3,3,3,3,3,3,3,3,3,3,30,null,19,{"$f":"'Calving input'!D36/2+'Calving input'!D37/2","v":10},{"$f":"V22","v":10},10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-10-31",19,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,20,{"$f":"'Calving input'!C37/2+'Calving input'!C38/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,20,{"$f":"'Calving input'!D37/2+'Calving input'!D38/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-11-30",20,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,21,{"$f":"'Calving input'!C38/2+'Calving input'!C39/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,21,{"$f":"'Calving input'!D38/2+'Calving input'!D39/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2020-12-31",21,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,22,{"$f":"'Calving input'!C39/2+'Calving input'!C40/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,22,{"$f":"'Calving input'!D39/2+'Calving input'!D40/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-01-31",22,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,23,{"$f":"'Calving input'!C40/2+'Calving input'!C41/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,23,{"$f":"'Calving input'!D40/2+'Calving input'!D41/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-02-28",23,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,76712.328767123312,7968.1274900398412,6772.9083665338649]
[null,null,null,24,{"$f":"'Calving input'!C41/2+'Calving input'!C42/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,24,{"$f":"'Calving input'!D41/2+'Calving input'!D42/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-03-31",24,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,25,{"$f":"'Calving input'!C42/2+'Calving input'!C44/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,25,{"$f":"'Calving input'!D42/2+'Calving input'!D44/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-04-30",25,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,26,{"$f":"'Calving input'!C44/2+'Calving input'!C45/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,26,{"$f":"'Calving input'!D44/2+'Calving input'!D45/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-05-31",26,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,27,{"$f":"'Calving input'!C45/2+'Calving input'!C46/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,27,{"$f":"'Calving input'!D45/2+'Calving input'!D46/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-06-30",27,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,28,{"$f":"'Calving input'!C46/2+'Calving input'!C47/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,28,{"$f":"'Calving input'!D46/2+'Calving input'!D47/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-07-31",28,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,29,{"$f":"'Calving input'!C47/2+'Calving input'!C48/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,29,{"$f":"'Calving input'!D47/2+'Calving input'!D48/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-08-31",29,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,30,{"$f":"'Calving input'!C48/2+'Calving input'!C49/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,30,{"$f":"'Calving input'!D48/2+'Calving input'!D49/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-09-30",30,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,31,{"$f":"'Calving input'!C49/2+'Calving input'!C50/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,31,{"$f":"'Calving input'!D49/2+'Calving input'!D50/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-10-31",31,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,32,{"$f":"'Calving input'!C50/2+'Calving input'!C51/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,32,{"$f":"'Calving input'!D50/2+'Calving input'!D51/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-11-30",32,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,82191.780821917826,7968.1274900398412,6772.9083665338649]
[null,null,null,33,{"$f":"'Calving input'!C51/2+'Calving input'!C52/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,33,{"$f":"'Calving input'!D51/2+'Calving input'!D52/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2021-12-31",33,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,34,{"$f":"'Calving input'!C52/2+'Calving input'!C53/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,34,{"$f":"'Calving input'!D52/2+'Calving input'!D53/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2022-01-31",34,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[null,null,null,35,{"$f":"'Calving input'!C53/2+'Calving input'!C54/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,35,{"$f":"'Calving input'!D53/2+'Calving input'!D54/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2022-02-28",35,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,76712.328767123312,7968.1274900398412,6772.9083665338649]
[null,null,null,36,{"$f":"'Calving input'!C54/2+'Calving input'!C55/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,30,null,36,{"$f":"'Calving input'!D54/2+'Calving input'!D55/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,100,null,"2022-03-31",36,2739.7260273972611,2739.7260273972602,2739.7260273972606,2739.7260273972606,2739.7260273972606,2739.7260273972602,2739.6703596572615,2739.7260273972597,2739.7260273972611,84931.50684931509,7968.1274900398412,6772.9083665338649]
[]
[null,null,"Month of","Lactation",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Mth 1-10 av"]
[null,null,"To yield","Heifers",0.85,1.1000000000000001,1.25,1.23,1.1399999999999999,1.05,0.97,0.88,0.8,0.73,0.65,0.59,0.54,0.49,{"$f":"AVERAGE(E43:N43)","v":1},"Feed to yield","High peak yield and reduced feed as milk yields fall, e.g. normal parlour feeding"]
[null,null,null,"Cows",0.99800399201596801,1.4171656686626746,1.3772455089820359,1.2275449101796407,1.1177644710578842,0.99800399201596801,0.8782435129740519,0.7684630738522954,0.65868263473053901,0.55888223552894212,0.46906187624750495,0.39920159680638723,0.3592814371257485,0.3293413173652695,{"$f":"AVERAGE(E44:N44)","v":1}]
[null,null,"Step rate","Heifers",0.8500000000000002,1.1400000000000001,1.2100000000000002,1.1600000000000001,1.1000000000000003,1.0500000000000003,0.9800000000000002,0.91000000000000025,0.82000000000000017,0.78000000000000025,0.72000000000000008,0.67000000000000015,0.62000000000000011,0.58000000000000007,1.0000000000000004,"Step rate","High peaks but cows fed in steps according to stage of lactation not yield"]
[null,null,null,"Cows",0.99999999999999978,1.2899999999999998,1.2799999999999998,1.2099999999999997,1.1099999999999999,1.0099999999999998,0.90999999999999981,0.81999999999999973,0.72999999999999987,0.6399999999999999,0.54999999999999993,0.46999999999999986,0.40999999999999986,0.34999999999999992,1]
[null,null,"Flat rate","Heifers",0.85,1.04,1.1299999999999999,1.1299999999999999,1.07,1.03,1,0.96,0.92,0.87,0.82,0.76,0.7,0.64,1,"Flat rate","Lower peaks with one fixed level of concentrates fed to all cows"]
[null,null,null,"Cows",1.0010010010010011,1.1611611611611612,1.1811811811811812,1.1811811811811812,1.0910910910910911,1.0210210210210211,0.95095095095095095,0.8808808808808809,0.81081081081081086,0.72072072072072069,0.64064064064064064,0.56056056056056058,0.49049049049049048,0.44044044044044045,0.99999999999999978]
[null,null,"total mixed diet","Heifers",0.84915084915084926,0.94905094905094911,1.0389610389610391,1.0889110889110891,1.1188811188811192,1.0989010989010992,1.0689310689310692,1.008991008991009,0.92907092907092925,0.84915084915084926,0.75924075924075929,0.68931068931068928,0.63936063936063947,0.59940059940059942,1.0000000000000002,"Total mixed ration","One mixed ration fed to all milking cows"]
[null,null,null,"Cows",0.99601593625498008,1.145418326693227,1.2250996015936255,1.2151394422310757,1.145418326693227,1.045816733067729,0.9561752988047808,0.85657370517928288,0.75697211155378485,0.65737051792828693,0.52788844621513942,0.42828685258964144,0.32868525896414347,0.22908366533864544,0.99999999999999978]
[null,null,"3x milking","Heifers",0.85,1.04,1.1200000000000001,1.1200000000000001,1.08,1.04,1,0.96,0.92,0.87,0.81,0.75,0.67,0.6,1,"Three times a day milking","TMR or partial mixed diet plus cake with 3x a day or robotic milking "]
[null,null,null,"Cows",0.99900099900099892,1.1988011988011986,1.2087912087912087,1.1388611388611387,1.0689310689310689,0.99900099900099892,0.94905094905094889,0.879120879120879,0.8091908091908091,0.74925074925074919,0.70929070929070914,0.64935064935064934,0.59940059940059931,0.54945054945054939,0.99999999999999978]
[null,null,"once a day","Heifers",0.85085085085085088,1.1811811811811812,1.2412412412412412,1.2412412412412412,1.1711711711711712,1.0610610610610611,0.97097097097097096,0.86086086086086089,0.76076076076076082,0.66066066066066065,0.55055055055055058,0.44044044044044045,0.36036036036036034,0.28028028028028029,0.99999999999999978,"Once a day milking","Predominantly grazing system but cows only milked once per day"]
[null,null,null,"Cows",0.99502487562189046,1.1343283582089549,1.2139303482587063,1.2238805970149251,1.1542288557213929,1.0547263681592038,0.9552238805970148,0.85572139303482575,0.7562189054726367,0.65671641791044777,0.54726368159203975,0.43781094527363179,0.35820895522388052,0.27860696517412936,0.99999999999999978]
[null,null,"Spring block","Heifers",1.119,1.224,1.1950000000000001,1.1339999999999999,1.0529999999999999,0.98699999999999999,0.92400000000000004,0.84699999999999998,0.78300000000000003,0.73299999999999998,0.66370378151260501,0.60056722689075626,0.54359033613445373,0.49123319327731096,0.99990000000000001,"Spring block","Intensively grazed, grass based system"]
[null,null,null,"Cows",1.2470000000000001,1.3260000000000001,1.2549999999999999,1.151,1.05,0.95899999999999996,0.874,0.78200000000000003,0.70499999999999996,0.65100000000000002,0.56289473684210534,0.48131578947368425,0.41605263157894734,0.35568421052631571,0.99999999999999978]
[null,null,"Autumn block","Heifers",1.0085325292206533,1.1134071253210633,1.1034208579922327,1.0795345079276712,1.0579943269428358,1.0249186612811936,0.98607954256498143,0.94467548067603457,0.88005323558789128,0.8013837324854417,0.72562266533870878,0.65659591527168537,0.59430348228437158,0.53706178710684016,1,"Autumn block","Herd fed to achieve maximum yield in winter and maximise grazing in spring"]
[null,null,null,"Cows",1.1461270712055274,1.2365325501792115,1.1874750050344074,1.1231929296529468,1.0626034361471524,1.0012465204998369,0.93745099404742571,0.85988181074630499,0.76715025333625197,0.67833942915093448,0.58653409287486813,0.50152915187851044,0.43352519908142423,0.37062154274411951,1]

{"sheet":"Hidden calculation alter","index":8,"n_rows":58,"n_cols":51,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Targets given",null,null,"Days",30,61,91,122,152,183,213,244,274,305,335,365,395,425]
[null,"start yield",null,"Retention",{"$f":"'Culling rate'!H5","v":1},{"$f":"IF(Input!$F$25-Input!F26>=F1,'Culling rate'!H6,IF(Input!$F$25-Input!F26<E1,0,(Input!$F$25-Input!F26-E1)/30))","v":1},{"$f":"IF(Input!$F$25-Input!F26>=G1,'Culling rate'!H7,IF(Input!$F$25-Input!F26<F1,0,(Input!$F$25-Input!F26-F1)/30))","v":1},{"$f":"IF(Input!$F$25-Input!F26>=H1,'Culling rate'!H8,IF(Input!$F$25-Input!F26<G1,0,(Input!$F$25-Input!F26-G1)/30))","v":1},{"$f":"IF(Input!$F$25-Input!F26>=I1,'Culling rate'!H9,IF(Input!$F$25-Input!F26<H1,0,(Input!$F$25-Input!F26-H1)/30))","v":0.8},{"$f":"IF(Input!$F$25-Input!F26>=J1,'Culling rate'!H10,IF(Input!$F$25-Input!F26<I1,0,(Input!$F$25-Input!F26-I1)/30))","v":0.64000000000000012},{"$f":"IF(Input!$F$25-Input!F26>=K1,'Culling rate'!H11,IF(Input!$F$25-Input!F26<J1,0,(Input!$F$25-Input!F26-J1)/30))","v":0.51200000000000012},{"$f":"IF(Input!$F$25-Input!F26>=L1,'Culling rate'!H12,IF(Input!$F$25-Input!F26<K1,0,(Input!$F$25-Input!F26-K1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=M1,'Culling rate'!H13,IF(Input!$F$25-Input!F26<L1,0,(Input!$F$25-Input!F26-L1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=N1,'Culling rate'!H14,IF(Input!$F$25-Input!F26<M1,0,(Input!$F$25-Input!F26-M1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=O1,'Culling rate'!H15,IF(Input!$F$25-Input!F26<N1,0,(Input!$F$25-Input!F26-N1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=P1,'Culling rate'!H16,IF(Input!$F$25-Input!F26<O1,0,(Input!$F$25-Input!F26-O1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=Q1,'Culling rate'!H17,IF(Input!$F$25-Input!F26<P1,0,(Input!$F$25-Input!F26-P1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=R1,'Culling rate'!H18,IF(Input!$F$25-Input!F26<Q1,0,(Input!$F$25-Input!F26-Q1)/30))","v":0},null,null,"Retention",{"$f":"'Culling rate'!I5","v":1},{"$f":"IF(Input!$F$25-Input!F26>=F1,'Culling rate'!$I6,IF(Input!$F$25-Input!F26<E1,0,(Input!$F$25-Input!F26-E1)/30))","v":1},{"$f":"IF(Input!$F$25-Input!F26>=G1,'Culling rate'!$I7,IF(Input!$F$25-Input!F26<F1,0,(Input!$F$25-Input!F26-F1)/30))","v":1},{"$f":"IF(Input!$F$25-Input!F26>=H1,'Culling rate'!$I8,IF(Input!$F$25-Input!F26<G1,0,(Input!$F$25-Input!F26-G1)/30))","v":1},{"$f":"IF(Input!$F$25-Input!F26>=I1,'Culling rate'!$I9,IF(Input!$F$25-Input!F26<H1,0,(Input!$F$25-Input!F26-H1)/30))","v":0.8},{"$f":"IF(Input!$F$25-Input!F26>=J1,'Culling rate'!$I10,IF(Input!$F$25-Input!F26<I1,0,(Input!$F$25-Input!F26-I1)/30))","v":0.64000000000000012},{"$f":"IF(Input!$F$25-Input!F26>=K1,'Culling rate'!$I11,IF(Input!$F$25-Input!F26<J1,0,(Input!$F$25-Input!F26-J1)/30))","v":0.51200000000000012},{"$f":"IF(Input!$F$25-Input!F26>=L1,'Culling rate'!$I12,IF(Input!$F$25-Input!F26<K1,0,(Input!$F$25-Input!F26-K1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=M1,'Culling rate'!$I13,IF(Input!$F$25-Input!F26<L1,0,(Input!$F$25-Input!F26-L1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=N1,'Culling rate'!$I14,IF(Input!$F$25-Input!F26<M1,0,(Input!$F$25-Input!F26-M1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=O1,'Culling rate'!$I15,IF(Input!$F$25-Input!F26<N1,0,(Input!$F$25-Input!F26-N1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=P1,'Culling rate'!$I16,IF(Input!$F$25-Input!F26<O1,0,(Input!$F$25-Input!F26-O1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=Q1,'Culling rate'!$I17,IF(Input!$F$25-Input!F26<P1,0,(Input!$F$25-Input!F26-P1)/30))","v":0},{"$f":"IF(Input!$F$25-Input!F26>=R1,'Culling rate'!$I18,IF(Input!$F$25-Input!F26<Q1,0,(Input!$F$25-Input!F26-Q1)/30))","v":0},null,null,null,"Used lookup",{"$f":"IF(Input!$F$27='Hidden calculation alter'!AN4,1,0)","v":1},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AO4,1,0)","v":0},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AP4,1,0)","v":0},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AQ4,1,0)","v":0},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AR4,1,0)","v":0},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AS4,1,0)","v":0},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AT4,1,0)","v":0},{"$f":"IF(Input!$F$27='Hidden calculation alter'!AU4,1,0)","v":0}]
["yield target ",{"$f":"Input!F30","v":7692.3076923076924},null,"Heifers","Lactation",{"$nulls":15},"Cows","Lactation",{"$nulls":17},1,2,3,4,5,6,7,8]
["Heifer yield as % of cows yield",{"$f":"Input!F15*100","v":85},null,"Month production",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Heifers-in-milk",null,"Month production",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Cows-in-milk",null,null,"Month production","Feed to yield","Step rate","Flat rate","Total mixed ration","Three times a day milking","Once a day milking","Spring Block","Autumn block","Yield used","Yield per month","Yield for cows","Yield for heifers"]
["No cows",{"$f":"'Calving input'!I17","v":120},null,1,{"$f":"'Calving input'!H$16/2+'Calving input'!H$18/2","v":3},{"$f":"'Calving input'!H$15/2+'Calving input'!H$16/2","v":3},{"$f":"'Calving input'!H$14/2+'Calving input'!H$15/2","v":3},{"$f":"'Calving input'!H$13/2+'Calving input'!H$14/2","v":3},{"$f":"'Calving input'!H$12/2+'Calving input'!H$13/2","v":3},{"$f":"'Calving input'!H$11/2+'Calving input'!H$12/2","v":3},{"$f":"'Calving input'!H$10/2+'Calving input'!H$11/2","v":3},{"$f":"'Calving input'!H$9/2+'Calving input'!H$10/2","v":3},{"$f":"'Calving input'!H$8/2+'Calving input'!H$9/2","v":3},{"$f":"'Calving input'!H$7/2+'Calving input'!H$8/2","v":3},{"$f":"'Calving input'!H$6/2+'Calving input'!H$7/2","v":3},{"$f":"'Calving input'!H$5/2+'Calving input'!H$6/2","v":3},{"$f":"'Calving input'!H$16/2+'Calving input'!H$5/2","v":3},{"$f":"'Calving input'!H$15/2+'Calving input'!H$16/2","v":3},{"$f":"ROUND(SUMPRODUCT(E5:R5,$E$2:$R$2),0)","v":18},null,1,{"$f":"'Calving input'!I$16/2+'Calving input'!I$18/2","v":10},{"$f":"'Calving input'!I$15/2+'Calving input'!I$16/2","v":10},{"$f":"'Calving input'!I$14/2+'Calving input'!I$15/2","v":10},{"$f":"'Calving input'!I$13/2+'Calving input'!I$14/2","v":10},{"$f":"'Calving input'!I$12/2+'Calving input'!I$13/2","v":10},{"$f":"'Calving input'!I$11/2+'Calving input'!I$12/2","v":10},{"$f":"'Calving input'!I$10/2+'Calving input'!I$11/2","v":10},{"$f":"'Calving input'!I$9/2+'Calving input'!I$10/2","v":10},{"$f":"'Calving input'!I$8/2+'Calving input'!I$9/2","v":10},{"$f":"'Calving input'!I$7/2+'Calving input'!I$8/2","v":10},{"$f":"'Calving input'!I$6/2+'Calving input'!I$7/2","v":10},{"$f":"'Calving input'!I$5/2+'Calving input'!I$6/2","v":10},{"$f":"'Calving input'!I$16/2+'Calving input'!I$5/2","v":10},{"$f":"'Calving input'!I$15/2+'Calving input'!I$16/2","v":10},{"$f":"ROUND(SUMPRODUCT(V5:AI5,$V$2:$AI$2),0)","v":60},null,{"$f":"Input!F9","v":"2019-04-30"},1,{"$f":"(SUMPRODUCT($E$43:$R$43,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$44:$R$44,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1891.1243988909159},{"$f":"(SUMPRODUCT($E$45:$R$45,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$46:$R$46,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1837.2163510342193},{"$f":"(SUMPRODUCT($E$47:$R$47,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$48:$R$48,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1771.0907029935574},{"$f":"(SUMPRODUCT($E$49:$R$49,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$50:$R$50,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1791.2336035321257},{"$f":"(SUMPRODUCT($E$51:$R$51,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$52:$R$52,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1768.1890794900676},{"$f":"(SUMPRODUCT($E$53:$R$53,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$54:$R$54,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1821.6890294000787},{"$f":"(SUMPRODUCT($E$55:$R$55,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$56:$R$56,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1870.4657184958796},{"$f":"(SUMPRODUCT($E$57:$R$57,$E$2:$R$2,$E5:$R5)*$AY5+SUMPRODUCT($E$58:$R$58,$V$2:$AI$2,$V5:$AI5)*$AX5)/365","v":1806.2045146699602},{"$f":"SUMPRODUCT(AN5:AU5,$AN$2:$AU$2)","v":1891.1243988909159},{"$f":"AV5*DAY(AL5)","v":56733.731966727479},{"$f":"$B$11*(1+$B$17*6.62)","v":7968.1274900398412},{"$f":"$B$12*(1+$B$17*6.62)","v":6772.9083665338649}]
["No heifers",{"$f":"'Calving input'!H17","v":36},null,2,{"$f":"'Calving input'!H18/2+'Calving input'!H19/2","v":3},{"$f":"E5","v":3},{"$f":"F5","v":3},3,3,3,3,3,3,3,3,3,3,3,{"$f":"ROUND(SUMPRODUCT(E6:R6,$E$2:$R$2),0)","v":18},null,2,{"$f":"'Calving input'!I18/2+'Calving input'!I19/2","v":10},{"$f":"V5","v":10},{"$f":"W5","v":10},10,10,10,10,10,10,10,10,10,10,10,{"$f":"ROUND(SUMPRODUCT(V6:AI6,$V$2:$AI$2),0)","v":60},null,{"$f":"EOMONTH(AL5,1)","v":"2019-05-31"},2,{"$f":"(SUMPRODUCT($E$43:$R$43,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$44:$R$44,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1891.1243988909159},{"$f":"(SUMPRODUCT($E$45:$R$45,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$46:$R$46,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1837.2163510342193},{"$f":"(SUMPRODUCT($E$47:$R$47,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$48:$R$48,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1771.0907029935574},{"$f":"(SUMPRODUCT($E$49:$R$49,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$50:$R$50,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1791.2336035321257},{"$f":"(SUMPRODUCT($E$51:$R$51,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$52:$R$52,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1768.1890794900676},{"$f":"(SUMPRODUCT($E$53:$R$53,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$54:$R$54,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1821.6890294000787},{"$f":"(SUMPRODUCT($E$55:$R$55,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$56:$R$56,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1870.4657184958796},{"$f":"(SUMPRODUCT($E$57:$R$57,$E$2:$R$2,$E6:$R6)*$AY6+SUMPRODUCT($E$58:$R$58,$V$2:$AI$2,$V6:$AI6)*$AX6)/365","v":1806.2045146699602},{"$f":"SUMPRODUCT(AN6:AU6,$AN$2:$AU$2)","v":1891.1243988909159},{"$f":"AV6*DAY(AL6)","v":58624.856365618391},{"$f":"AX5*(1+$B$17)","v":7968.1274900398412},{"$f":"AY5*(1+$B$17)","v":6772.9083665338649}]
["heifers as cow",{"$f":"B6*B4/100","v":30.6},null,3,{"$f":"'Calving input'!H19/2+'Calving input'!H20/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,3,{"$f":"'Calving input'!I19/2+'Calving input'!I20/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,{"$f":"EOMONTH(AL6,1)","v":"2019-06-30"},3,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,{"$f":"AX6*(1+$B$17)","v":7968.1274900398412},{"$f":"AY6*(1+$B$17)","v":6772.9083665338649}]
["equivalents",null,null,4,{"$f":"'Calving input'!H20/2+'Calving input'!H21/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,4,{"$f":"'Calving input'!I20/2+'Calving input'!I21/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2019-07-31",4,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["Total cow equivalents",{"$f":"B7+B5","v":150.6},null,5,{"$f":"'Calving input'!H21/2+'Calving input'!H22/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,5,{"$f":"'Calving input'!I21/2+'Calving input'!I22/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2019-08-31",5,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["yield per cow equiv",{"$f":"IF(B9>0,((B5+B6)*B3)/B9,0)","v":7968.1274900398412},null,6,{"$f":"'Calving input'!H22/2+'Calving input'!H23/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,6,{"$f":"'Calving input'!I22/2+'Calving input'!I23/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2019-09-30",6,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
["Cow yield",{"$f":"B10","v":7968.1274900398412},null,7,{"$f":"'Calving input'!H23/2+'Calving input'!H24/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,7,{"$f":"'Calving input'!I23/2+'Calving input'!I24/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2019-10-31",7,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["Heifer yield",{"$f":"B11*B4/100","v":6772.9083665338649},null,8,{"$f":"'Calving input'!H24/2+'Calving input'!H25/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,8,{"$f":"'Calving input'!I24/2+'Calving input'!I25/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2019-11-30",8,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,9,{"$f":"'Calving input'!H25/2+'Calving input'!H26/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,9,{"$f":"'Calving input'!I25/2+'Calving input'!I26/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2019-12-31",9,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["Av cows-in-milk",{"$f":"SUM($S5:$S16,$AJ5:$AJ16)/12","v":78},null,10,{"$f":"'Calving input'!H26/2+'Calving input'!H27/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,10,{"$f":"'Calving input'!I26/2+'Calving input'!I27/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-01-31",10,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,11,{"$f":"'Calving input'!H27/2+'Calving input'!H28/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,11,{"$f":"'Calving input'!I27/2+'Calving input'!I28/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-02-29",11,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,54842.60756783656,7968.1274900398412,6772.9083665338649]
[null,null,null,12,{"$f":"'Calving input'!H28/2+'Calving input'!H29/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,12,{"$f":"'Calving input'!I28/2+'Calving input'!I29/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-03-31",12,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["Yield monthly change",{"$f":"IF(Input!F31=0,0,IF(Input!F31<0,Input!F31,NOMINAL(Input!F31,12)))/12","v":0},null,13,{"$f":"'Calving input'!H29/2+'Calving input'!H31/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,13,{"$f":"'Calving input'!I29/2+'Calving input'!I31/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-04-30",13,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,14,{"$f":"'Calving input'!H31/2+'Calving input'!H32/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,14,{"$f":"'Calving input'!I31/2+'Calving input'!I32/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-05-31",14,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["Yield for charts",null,null,15,{"$f":"'Calving input'!H32/2+'Calving input'!H33/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,15,{"$f":"'Calving input'!I32/2+'Calving input'!I33/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-06-30",15,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
["Cow yield",{"$f":"IF(B11<>0,B11,Input!F30)","v":7968.1274900398412},null,16,{"$f":"'Calving input'!H33/2+'Calving input'!H34/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,16,{"$f":"'Calving input'!I33/2+'Calving input'!I34/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-07-31",16,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
["Heifer yield",{"$f":"IF(B12<>0,B12,Input!F30*Input!F15)","v":6772.9083665338649},null,17,{"$f":"'Calving input'!H34/2+'Calving input'!H35/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,17,{"$f":"'Calving input'!I34/2+'Calving input'!I35/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-08-31",17,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,18,{"$f":"'Calving input'!H35/2+'Calving input'!H36/2","v":3},3,{"$f":"F21","v":3},3,3,3,3,3,3,3,3,3,3,3,18,null,18,{"$f":"'Calving input'!I35/2+'Calving input'!I36/2","v":10},10,{"$f":"W21","v":10},10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-09-30",18,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,19,{"$f":"'Calving input'!H36/2+'Calving input'!H37/2","v":3},{"$f":"E22","v":3},3,3,3,3,3,3,3,3,3,3,3,3,18,null,19,{"$f":"'Calving input'!I36/2+'Calving input'!I37/2","v":10},{"$f":"V22","v":10},10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-10-31",19,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,20,{"$f":"'Calving input'!H37/2+'Calving input'!H38/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,20,{"$f":"'Calving input'!I37/2+'Calving input'!I38/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-11-30",20,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,21,{"$f":"'Calving input'!H38/2+'Calving input'!H39/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,21,{"$f":"'Calving input'!I38/2+'Calving input'!I39/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2020-12-31",21,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,22,{"$f":"'Calving input'!H39/2+'Calving input'!H40/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,22,{"$f":"'Calving input'!I39/2+'Calving input'!I40/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-01-31",22,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,23,{"$f":"'Calving input'!H40/2+'Calving input'!H41/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,23,{"$f":"'Calving input'!I40/2+'Calving input'!I41/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-02-28",23,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,52951.483168945648,7968.1274900398412,6772.9083665338649]
[null,null,null,24,{"$f":"'Calving input'!H41/2+'Calving input'!H42/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,24,{"$f":"'Calving input'!I41/2+'Calving input'!I42/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-03-31",24,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,25,{"$f":"'Calving input'!H42/2+'Calving input'!H44/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,25,{"$f":"'Calving input'!I42/2+'Calving input'!I44/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-04-30",25,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,26,{"$f":"'Calving input'!H44/2+'Calving input'!H45/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,26,{"$f":"'Calving input'!I44/2+'Calving input'!I45/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-05-31",26,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,27,{"$f":"'Calving input'!H45/2+'Calving input'!H46/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,27,{"$f":"'Calving input'!I45/2+'Calving input'!I46/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-06-30",27,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,28,{"$f":"'Calving input'!H46/2+'Calving input'!H47/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,28,{"$f":"'Calving input'!I46/2+'Calving input'!I47/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-07-31",28,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,29,{"$f":"'Calving input'!H47/2+'Calving input'!H48/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,29,{"$f":"'Calving input'!I47/2+'Calving input'!I48/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-08-31",29,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,30,{"$f":"'Calving input'!H48/2+'Calving input'!H49/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,30,{"$f":"'Calving input'!I48/2+'Calving input'!I49/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-09-30",30,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,31,{"$f":"'Calving input'!H49/2+'Calving input'!H50/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,31,{"$f":"'Calving input'!I49/2+'Calving input'!I50/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-10-31",31,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,32,{"$f":"'Calving input'!H50/2+'Calving input'!H51/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,32,{"$f":"'Calving input'!I50/2+'Calving input'!I51/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-11-30",32,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,56733.731966727479,7968.1274900398412,6772.9083665338649]
[null,null,null,33,{"$f":"'Calving input'!H51/2+'Calving input'!H52/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,33,{"$f":"'Calving input'!I51/2+'Calving input'!I52/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2021-12-31",33,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,34,{"$f":"'Calving input'!H52/2+'Calving input'!H53/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,34,{"$f":"'Calving input'!I52/2+'Calving input'!I53/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2022-01-31",34,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[null,null,null,35,{"$f":"'Calving input'!H53/2+'Calving input'!H54/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,35,{"$f":"'Calving input'!I53/2+'Calving input'!I54/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2022-02-28",35,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,52951.483168945648,7968.1274900398412,6772.9083665338649]
[null,null,null,36,{"$f":"'Calving input'!H54/2+'Calving input'!H55/2","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,18,null,36,{"$f":"'Calving input'!I54/2+'Calving input'!I55/2","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,60,null,"2022-03-31",36,1891.1243988909159,1837.2163510342193,1771.0907029935574,1791.2336035321257,1768.1890794900676,1821.6890294000787,1870.4657184958796,1806.2045146699602,1891.1243988909159,58624.856365618391,7968.1274900398412,6772.9083665338649]
[]
[null,null,"Month of","Lactation",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Mth 1-10 av"]
[null,null,"To yield","Heifers",0.85,1.1000000000000001,1.25,1.23,1.1399999999999999,1.05,0.97,0.88,0.8,0.73,0.65,0.59,0.54,0.49,{"$f":"AVERAGE(E43:N43)","v":1},"Feed to yield","High peak yield and reduced feed as milk yields fall, e.g. normal parlour feeding"]
[null,null,null,"Cows",0.99800399201596801,1.4171656686626746,1.3772455089820359,1.2275449101796407,1.1177644710578842,0.99800399201596801,0.8782435129740519,0.7684630738522954,0.65868263473053901,0.55888223552894212,0.46906187624750495,0.39920159680638723,0.3592814371257485,0.3293413173652695,{"$f":"AVERAGE(E44:N44)","v":1}]
[null,null,"Step rate","Heifers",0.8500000000000002,1.1400000000000001,1.2100000000000002,1.1600000000000001,1.1000000000000003,1.0500000000000003,0.9800000000000002,0.91000000000000025,0.82000000000000017,0.78000000000000025,0.72000000000000008,0.67000000000000015,0.62000000000000011,0.58000000000000007,1.0000000000000004,"Step rate","High peaks but cows fed in steps according to stage of lactation not yield"]
[null,null,null,"Cows",0.99999999999999978,1.2899999999999998,1.2799999999999998,1.2099999999999997,1.1099999999999999,1.0099999999999998,0.90999999999999981,0.81999999999999973,0.72999999999999987,0.6399999999999999,0.54999999999999993,0.46999999999999986,0.40999999999999986,0.34999999999999992,1]
[null,null,"Flat rate","Heifers",0.85,1.04,1.1299999999999999,1.1299999999999999,1.07,1.03,1,0.96,0.92,0.87,0.82,0.76,0.7,0.64,1,"Flat rate","Lower peaks with one fixed level of concentrates fed to all cows"]
[null,null,null,"Cows",1.0010010010010011,1.1611611611611612,1.1811811811811812,1.1811811811811812,1.0910910910910911,1.0210210210210211,0.95095095095095095,0.8808808808808809,0.81081081081081086,0.72072072072072069,0.64064064064064064,0.56056056056056058,0.49049049049049048,0.44044044044044045,0.99999999999999978]
[null,null,"total mixed diet","Heifers",0.84915084915084926,0.94905094905094911,1.0389610389610391,1.0889110889110891,1.1188811188811192,1.0989010989010992,1.0689310689310692,1.008991008991009,0.92907092907092925,0.84915084915084926,0.75924075924075929,0.68931068931068928,0.63936063936063947,0.59940059940059942,1.0000000000000002,"Total mixed ration","One mixed ration fed to all milking cows"]
[null,null,null,"Cows",0.99601593625498008,1.145418326693227,1.2250996015936255,1.2151394422310757,1.145418326693227,1.045816733067729,0.9561752988047808,0.85657370517928288,0.75697211155378485,0.65737051792828693,0.52788844621513942,0.42828685258964144,0.32868525896414347,0.22908366533864544,0.99999999999999978]
[null,null,"3x milking","Heifers",0.85,1.04,1.1200000000000001,1.1200000000000001,1.08,1.04,1,0.96,0.92,0.87,0.81,0.75,0.67,0.6,1,"Three times a day milking","TMR or partial mixed diet plus cake with 3x a day or robotic milking "]
[null,null,null,"Cows",0.99900099900099892,1.1988011988011986,1.2087912087912087,1.1388611388611387,1.0689310689310689,0.99900099900099892,0.94905094905094889,0.879120879120879,0.8091908091908091,0.74925074925074919,0.70929070929070914,0.64935064935064934,0.59940059940059931,0.54945054945054939,0.99999999999999978]
[null,null,"once a day","Heifers",0.85085085085085088,1.1811811811811812,1.2412412412412412,1.2412412412412412,1.1711711711711712,1.0610610610610611,0.97097097097097096,0.86086086086086089,0.76076076076076082,0.66066066066066065,0.55055055055055058,0.44044044044044045,0.36036036036036034,0.28028028028028029,0.99999999999999978,"Once a day milking","Predominantly grazing system but cows only milked once per day"]
[null,null,null,"Cows",0.99502487562189046,1.1343283582089549,1.2139303482587063,1.2238805970149251,1.1542288557213929,1.0547263681592038,0.9552238805970148,0.85572139303482575,0.7562189054726367,0.65671641791044777,0.54726368159203975,0.43781094527363179,0.35820895522388052,0.27860696517412936,0.99999999999999978]
[null,null,"Spring block","Heifers",1.119,1.224,1.1950000000000001,1.1339999999999999,1.0529999999999999,0.98699999999999999,0.92400000000000004,0.84699999999999998,0.78300000000000003,0.73299999999999998,0.66370378151260501,0.60056722689075626,0.54359033613445373,0.49123319327731096,0.99990000000000001,"Spring block","Intensively grazed, grass based system"]
[null,null,null,"Cows",1.2470000000000001,1.3260000000000001,1.2549999999999999,1.151,1.05,0.95899999999999996,0.874,0.78200000000000003,0.70499999999999996,0.65100000000000002,0.56289473684210534,0.48131578947368425,0.41605263157894734,0.35568421052631571,0.99999999999999978]
[null,null,"Autumn block","Heifers",1.0085325292206533,1.1134071253210633,1.1034208579922327,1.0795345079276712,1.0579943269428358,1.0249186612811936,0.98607954256498143,0.94467548067603457,0.88005323558789128,0.8013837324854417,0.72562266533870878,0.65659591527168537,0.59430348228437158,0.53706178710684016,{"$f":"AVERAGE(E57:N57)","v":1},"Autumn block","Herd fed to achieve maximum yield in winter and maximise grazing in spring"]
[null,null,null,"Cows",1.1461270712055274,1.2365325501792115,1.1874750050344074,1.1231929296529468,1.0626034361471524,1.0012465204998369,0.93745099404742571,0.85988181074630499,0.76715025333625197,0.67833942915093448,0.58653409287486813,0.50152915187851044,0.43352519908142423,0.37062154274411951,1]

{"sheet":"Yields for charts","index":9,"n_rows":45,"n_cols":27,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,"Type",{"$nulls":16},"Selected chart 1",null,"To plot",null,null,"Alternative chart",null,"To plot"]
["Month of","Feed to yield",null,"Step rate",null,"Flat rate",null,"Total mixed diet",null,"3x milking",null,"Once a day",null,"Spring block",null,"Autumn block"]
["Lactation","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Days","Heifers","Cows","Heifers","Cows",null,"Heifers","Cows","Heifers","Cows"]
[1,{"$f":"B29","v":0.85},{"$f":"C29","v":1},0.85,1,0.85,1,0.85,1,0.85,1,0.85,1,1.119,1.2470000000000001,1.0085325292206533,1.1461270712055274,{"$f":"A4*30","v":30},{"$f":"B4*$B$23+D4*$D$23+F4*$F$23+H4*$H$23+J4*$J$23+L4*$L$23+N4*$N$23+P4*$P$23","v":15.772526333024068},{"$f":"C4*$C$23+E4*$E$23+G4*$G$23+I4*$I$23+K4*$K$23+M4*$M$23+O4*$O$23+Q4*$Q$23","v":21.830486274081757},{"$f":"IF(Input!$F$12-Input!$F$13>$R4-15,'Yields for charts'!S4,0)","v":15.772526333024068},{"$f":"IF(Input!$F$12-Input!$F$13>$R4-15,'Yields for charts'!T4,0)","v":21.830486274081757},null,{"$f":"B4*$B$24+D4*$D$24+F4*$F$24+H4*$H$24+J4*$J$24+L4*$L$24+N4*$N$24+P4*$P$24","v":15.772526333024068},{"$f":"C4*$C$24+E4*$E$24+G4*$G$24+I4*$I$24+K4*$K$24+M4*$M$24+O4*$O$24+Q4*$Q$24","v":21.830486274081757},{"$f":"IF(Input!$F$25-Input!$F$26>$R4-15,'Yields for charts'!X4,0)","v":15.772526333024068},{"$f":"IF(Input!$F$25-Input!$F$26>$R4-15,'Yields for charts'!Y4,0)","v":21.830486274081757}]
[2,{"$f":"B30","v":1.1000000000000001},1.42,1.1399999999999999,1.29,1.04,1.1599999999999999,0.95,1.1499999999999999,1.04,1.2,1.18,1.1399999999999999,1.224,1.3260000000000001,1.1134071253210633,1.2365325501792115,{"$f":"A5*30","v":60},{"$f":"B5*$B$23+D5*$D$23+F5*$F$23+H5*$H$23+J5*$J$23+L5*$L$23+N5*$N$23+P5*$P$23","v":20.411504666266442},{"$f":"C5*$C$23+E5*$E$23+G5*$G$23+I5*$I$23+K5*$K$23+M5*$M$23+O5*$O$23+Q5*$Q$23","v":30.999290509196094},{"$f":"IF(Input!$F$12-Input!$F$13>$R5-15,'Yields for charts'!S5,0)","v":20.411504666266442},{"$f":"IF(Input!$F$12-Input!$F$13>$R5-15,'Yields for charts'!T5,0)","v":30.999290509196094},null,20.411504666266442,30.999290509196094,{"$f":"IF(Input!$F$25-Input!$F$26>$R5-15,'Yields for charts'!X5,0)","v":20.411504666266442},{"$f":"IF(Input!$F$25-Input!$F$26>$R5-15,'Yields for charts'!Y5,0)","v":30.999290509196094}]
[3,{"$f":"B31","v":1.25},1.38,1.21,1.28,1.1299999999999999,1.18,1.04,1.23,1.1200000000000001,1.21,1.24,1.22,1.1950000000000001,1.2549999999999999,1.1034208579922327,1.1874750050344074,90,23.194891666211866,30.126071058232821,{"$f":"IF(Input!$F$12-Input!$F$13>$R6-15,'Yields for charts'!S6,0)","v":23.194891666211866},{"$f":"IF(Input!$F$12-Input!$F$13>$R6-15,'Yields for charts'!T6,0)","v":30.126071058232821},null,23.194891666211866,30.126071058232821,{"$f":"IF(Input!$F$25-Input!$F$26>$R6-15,'Yields for charts'!X6,0)","v":23.194891666211866},{"$f":"IF(Input!$F$25-Input!$F$26>$R6-15,'Yields for charts'!Y6,0)","v":30.126071058232821}]
[4,{"$f":"B32","v":1.23},1.23,1.1599999999999999,1.21,1.1299999999999999,1.18,1.0900000000000001,1.22,1.1200000000000001,1.1399999999999999,1.24,1.23,1.1339999999999999,1.151,1.0795345079276712,1.1231929296529468,120,22.823773399552476,26.85149811712056,{"$f":"IF(Input!$F$12-Input!$F$13>$R7-15,'Yields for charts'!S7,0)","v":22.823773399552476},{"$f":"IF(Input!$F$12-Input!$F$13>$R7-15,'Yields for charts'!T7,0)","v":26.85149811712056},null,22.823773399552476,26.85149811712056,{"$f":"IF(Input!$F$25-Input!$F$26>$R7-15,'Yields for charts'!X7,0)","v":22.823773399552476},{"$f":"IF(Input!$F$25-Input!$F$26>$R7-15,'Yields for charts'!Y7,0)","v":26.85149811712056}]
[5,{"$f":"B33","v":1.1399999999999999},1.1200000000000001,1.1000000000000001,1.1100000000000001,1.07,1.0900000000000001,1.1200000000000001,1.1499999999999999,1.08,1.07,1.17,1.1599999999999999,1.0529999999999999,1.05,1.0579943269428358,1.0626034361471524,150,21.15374119958522,24.450144626971571,{"$f":"IF(Input!$F$12-Input!$F$13>$R8-15,'Yields for charts'!S8,0)","v":21.15374119958522},{"$f":"IF(Input!$F$12-Input!$F$13>$R8-15,'Yields for charts'!T8,0)","v":24.450144626971571},null,21.15374119958522,24.450144626971571,{"$f":"IF(Input!$F$25-Input!$F$26>$R8-15,'Yields for charts'!X8,0)","v":21.15374119958522},{"$f":"IF(Input!$F$25-Input!$F$26>$R8-15,'Yields for charts'!Y8,0)","v":24.450144626971571}]
[6,{"$f":"B34","v":1.05},1,1.05,1.01,1.03,1.02,1.1000000000000001,1.05,1.04,1,1.06,1.06,0.98699999999999999,0.95899999999999996,1.0249186612811936,1.0012465204998369,180,19.483708999617967,21.830486274081757,{"$f":"IF(Input!$F$12-Input!$F$13>$R9-15,'Yields for charts'!S9,0)","v":19.483708999617967},{"$f":"IF(Input!$F$12-Input!$F$13>$R9-15,'Yields for charts'!T9,0)","v":21.830486274081757},null,19.483708999617967,21.830486274081757,{"$f":"IF(Input!$F$25-Input!$F$26>$R9-15,'Yields for charts'!X9,0)","v":19.483708999617967},{"$f":"IF(Input!$F$25-Input!$F$26>$R9-15,'Yields for charts'!Y9,0)","v":21.830486274081757}]
[7,{"$f":"B35","v":0.97},0.88,0.98,0.91,1,0.95,1.07,0.96,1,0.95,0.97,0.96,0.92400000000000004,0.874,0.98607954256498143,0.93745099404742571,210,17.999235932980408,19.210827921191946,{"$f":"IF(Input!$F$12-Input!$F$13>$R10-15,'Yields for charts'!S10,0)","v":17.999235932980408},{"$f":"IF(Input!$F$12-Input!$F$13>$R10-15,'Yields for charts'!T10,0)","v":19.210827921191946},null,17.999235932980408,19.210827921191946,{"$f":"IF(Input!$F$25-Input!$F$26>$R10-15,'Yields for charts'!X10,0)","v":17.999235932980408},{"$f":"IF(Input!$F$25-Input!$F$26>$R10-15,'Yields for charts'!Y10,0)","v":19.210827921191946}]
[8,{"$f":"B36","v":0.88},0.77,0.91,0.82,0.96,0.88,1.01,0.86,0.96,0.88,0.86,0.86,0.84699999999999998,0.78200000000000003,0.94467548067603457,0.85988181074630499,240,16.329203733013152,16.809474431042954,{"$f":"IF(Input!$F$12-Input!$F$13>$R11-15,'Yields for charts'!S11,0)","v":16.329203733013152},{"$f":"IF(Input!$F$12-Input!$F$13>$R11-15,'Yields for charts'!T11,0)","v":16.809474431042954},null,16.329203733013152,16.809474431042954,{"$f":"IF(Input!$F$25-Input!$F$26>$R11-15,'Yields for charts'!X11,0)","v":16.329203733013152},{"$f":"IF(Input!$F$25-Input!$F$26>$R11-15,'Yields for charts'!Y11,0)","v":16.809474431042954}]
[9,{"$f":"B37","v":0.8},0.66,0.82,0.73,0.92,0.81,0.93,0.76,0.92,0.81,0.76,0.76,0.78300000000000003,0.70499999999999996,0.88005323558789128,0.76715025333625197,270,14.844730666375595,14.40812094089396,{"$f":"IF(Input!$F$12-Input!$F$13>$R12-15,'Yields for charts'!S12,0)","v":14.844730666375595},{"$f":"IF(Input!$F$12-Input!$F$13>$R12-15,'Yields for charts'!T12,0)","v":14.40812094089396},null,14.844730666375595,14.40812094089396,{"$f":"IF(Input!$F$25-Input!$F$26>$R12-15,'Yields for charts'!X12,0)","v":14.844730666375595},{"$f":"IF(Input!$F$25-Input!$F$26>$R12-15,'Yields for charts'!Y12,0)","v":14.40812094089396}]
[10,{"$f":"B38","v":0.73},0.56000000000000005,0.78,0.64,0.87,0.72,0.85,0.66,0.87,0.75,0.66,0.66,0.73299999999999998,0.65100000000000002,0.8013837324854417,0.67833942915093448,300,13.545816733067729,12.225072313485786,{"$f":"IF(Input!$F$12-Input!$F$13>$R13-15,'Yields for charts'!S13,0)","v":13.545816733067729},{"$f":"IF(Input!$F$12-Input!$F$13>$R13-15,'Yields for charts'!T13,0)","v":12.225072313485786},null,13.545816733067729,12.225072313485786,{"$f":"IF(Input!$F$25-Input!$F$26>$R13-15,'Yields for charts'!X13,0)","v":13.545816733067729},{"$f":"IF(Input!$F$25-Input!$F$26>$R13-15,'Yields for charts'!Y13,0)","v":12.225072313485786}]
[11,{"$f":"B39","v":0.65},0.47,0.72,0.55000000000000004,0.82,0.64,0.76,0.53,0.81,0.71,0.55000000000000004,0.55000000000000004,0.66370378151260501,0.56289473684210534,0.72562266533870878,0.58653409287486813,330,12.061343666430171,10.260328548818425,{"$f":"IF(Input!$F$12-Input!$F$13>$R14-15,'Yields for charts'!S14,0)","v":0},{"$f":"IF(Input!$F$12-Input!$F$13>$R14-15,'Yields for charts'!T14,0)","v":0},null,12.061343666430171,10.260328548818425,{"$f":"IF(Input!$F$25-Input!$F$26>$R14-15,'Yields for charts'!X14,0)","v":0},{"$f":"IF(Input!$F$25-Input!$F$26>$R14-15,'Yields for charts'!Y14,0)","v":0}]
[12,{"$f":"B40","v":0.59},0.4,0.67,0.47,0.76,0.56000000000000005,0.69,0.43,0.75,0.65,0.44,0.44,0.60056722689075626,0.48131578947368425,0.65659591527168537,0.50152915187851044,360,10.947988866452,8.7321945096327038,{"$f":"IF(Input!$F$12-Input!$F$13>$R15-15,'Yields for charts'!S15,0)","v":0},{"$f":"IF(Input!$F$12-Input!$F$13>$R15-15,'Yields for charts'!T15,0)","v":0},null,10.947988866452,8.7321945096327038,{"$f":"IF(Input!$F$25-Input!$F$26>$R15-15,'Yields for charts'!X15,0)","v":0},{"$f":"IF(Input!$F$25-Input!$F$26>$R15-15,'Yields for charts'!Y15,0)","v":0}]
[13,{"$f":"B41","v":0.54},0.36,0.62,0.41,0.7,0.49,0.64,0.33,0.67,0.6,0.36,0.36,0.54359033613445373,0.41605263157894734,0.59430348228437158,0.43352519908142423,390,10.020193199803526,7.858975058669432,{"$f":"IF(Input!$F$12-Input!$F$13>$R16-15,'Yields for charts'!S16,0)","v":0},{"$f":"IF(Input!$F$12-Input!$F$13>$R16-15,'Yields for charts'!T16,0)","v":0},null,10.020193199803526,7.858975058669432,{"$f":"IF(Input!$F$25-Input!$F$26>$R16-15,'Yields for charts'!X16,0)","v":0},{"$f":"IF(Input!$F$25-Input!$F$26>$R16-15,'Yields for charts'!Y16,0)","v":0}]
[14,{"$f":"B42","v":0.49},0.33,0.57999999999999996,0.35,0.64,0.44,0.6,0.23,0.6,0.55000000000000004,0.28000000000000003,0.28000000000000003,0.49123319327731096,0.35568421052631571,0.53706178710684016,0.37062154274411951,420,9.0923975331550508,7.2040604704469802,{"$f":"IF(Input!$F$12-Input!$F$13>$R17-15,'Yields for charts'!S17,0)","v":0},{"$f":"IF(Input!$F$12-Input!$F$13>$R17-15,'Yields for charts'!T17,0)","v":0},null,9.0923975331550508,7.2040604704469802,{"$f":"IF(Input!$F$25-Input!$F$26>$R17-15,'Yields for charts'!X17,0)","v":0},{"$f":"IF(Input!$F$25-Input!$F$26>$R17-15,'Yields for charts'!Y17,0)","v":0}]
[]
[]
[null,"Feed to yield",null,"Step rate",null,"Flat rate",null,"Total mixed ration",null,"Three times a day milking",null,"Once a day milking",null,"Spring block",null,"Autumn block"]
[null,"High Peak yield and reduce feed as milk yields fall, e.g. normal parlour feeding",null,"High peaks but cows fed in steps according to stage of lactation not yield",null,"Lower peaks with one fixed level of concentrates fed to all cows",null,"One mixed ration fed to all milking cows",null,"TMR or partial mixed diet plus cake with 3x a day or robotic milking ",null,"Predominantly grazing system but cows only milked once per day",null,"Intensively grazed, grass based system",null,"Herd fed to achieve maximum yield in winter and maximise grazing in spring"]
[]
["Current",{"$f":"IF(Input!$F$14=B20,'Hidden calculation original'!$B$21/365,0)","v":18.555913332969492},{"$f":"IF(Input!$F$14=B20,'Hidden calculation original'!$B$20/365,0)","v":21.830486274081757},{"$f":"IF(Input!$F$14=D20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=D20,'Hidden calculation original'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$14=F20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=F20,'Hidden calculation original'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$14=H20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=H20,'Hidden calculation original'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$14=J20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=J20,'Hidden calculation original'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$14=L20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=L20,'Hidden calculation original'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$14=N20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=N20,'Hidden calculation original'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$14=P20,'Hidden calculation original'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$14=P20,'Hidden calculation original'!$B$20/365,0)","v":0}]
["Alternative",{"$f":"IF(Input!$F$27=B20,'Hidden calculation alter'!$B$21/365,0)","v":18.555913332969492},{"$f":"IF(Input!$F$27=B20,'Hidden calculation alter'!$B$20/365,0)","v":21.830486274081757},{"$f":"IF(Input!$F$27=D20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=D20,'Hidden calculation alter'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$27=F20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=F20,'Hidden calculation alter'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$27=H20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=H20,'Hidden calculation alter'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$27=J20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=J20,'Hidden calculation alter'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$27=L20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=L20,'Hidden calculation alter'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$27=N20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=N20,'Hidden calculation alter'!$B$20/365,0)","v":0},{"$f":"IF(Input!$F$27=P20,'Hidden calculation alter'!$B$21/365,0)","v":0},{"$f":"IF(Input!$F$27=P20,'Hidden calculation alter'!$B$20/365,0)","v":0}]
[]
[{"$nulls":18},"Raw data",null,"Raw data"]
["Month of","Feed to yield",null,"Step rate",null,"Flat rate",null,"Total mixed ration",null,"Three times a day milking",null,"Once a day milking",null,"Spring block",null,"Autumn block",null,null,"Spring block",null,"Autumn block",null,null,"Averages"]
["Lactation","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows","Heifers","Cows",null,"Heifers","Cows","Heifers","Cows",null,"Heifers","Cows"]
[1,0.85,1,0.85,1,0.85,1,0.85,1,0.85,1,0.85,1,1.119,1.2470000000000001,{"$f":"U29/U$43","v":1.0085325292206533},{"$f":"V29/V$43","v":1.1461270712055274},null,20.107605633802802,27.998290686123401,22.5147975230981,31.5529263687854,null,{"$f":"AVERAGE(B29,D29,F29,H29,J29,L29)","v":0.85},{"$f":"AVERAGE(C29,E29,G29,I29,K29,M29)","v":1}]
[2,1.1000000000000001,1.42,1.1399999999999999,1.29,1.04,1.1599999999999999,0.95,1.1499999999999999,1.04,1.2,1.18,1.1399999999999999,1.224,1.3260000000000001,{"$f":"U30/U$43","v":1.1134071253210633},1.2365325501792115,null,22.006690568789502,29.7693336140646,24.856051005860898,34.0417929988974,null,1.075,1.2266666666666666]
[3,1.25,1.38,1.21,1.28,1.1299999999999999,1.18,1.04,1.23,1.1200000000000001,1.21,1.24,1.22,1.1950000000000001,1.2549999999999999,1.1034208579922327,1.1874750050344074,null,21.483601342993499,28.1658459644533,24.6331144317735,32.691236722306499,null,1.165,1.25]
[4,1.23,1.23,1.1599999999999999,1.21,1.1299999999999999,1.18,1.0900000000000001,1.22,1.1200000000000001,1.1399999999999999,1.24,1.23,1.1339999999999999,1.151,1.0795345079276712,1.1231929296529468,null,20.383330381913702,25.826076697694901,24.099868036949701,30.921548489386101,null,1.1616666666666666,1.2016666666666664]
[5,1.1399999999999999,1.1200000000000001,1.1000000000000001,1.1100000000000001,1.07,1.0900000000000001,1.1200000000000001,1.1499999999999999,1.08,1.07,1.17,1.1599999999999999,1.0529999999999999,1.05,1.0579943269428358,1.0626034361471524,null,18.926958095015799,23.562961702573201,23.6189982588978,29.253517190466098,null,1.1133333333333335,1.1166666666666669]
[6,1.05,1,1.05,1.01,1.03,1.02,1.1000000000000001,1.05,1.04,1,1.06,1.06,0.98699999999999999,0.95899999999999996,1.0249186612811936,1.0012465204998369,null,17.749960897551599,21.531268153527002,22.880606691211799,27.564358727784299,null,1.0549999999999999,1.0233333333333334]
[7,0.97,0.88,0.98,0.91,1,0.95,1.07,0.96,1,0.95,0.97,0.96,0.92400000000000004,0.874,0.98607954256498143,0.93745099404742571,null,16.611076140902998,19.607224294086301,22.0135499840307,25.808065207299201,null,0.99833333333333341,0.93500000000000005]
[8,0.88,0.77,0.91,0.82,0.96,0.88,1.01,0.86,0.96,0.88,0.86,0.86,0.84699999999999998,0.78200000000000003,0.94467548067603457,0.85988181074630499,null,15.221920938851101,17.554448753778601,21.0892326783868,23.672582335742302,null,0.93,0.84500000000000008]
[9,0.8,0.66,0.82,0.73,0.92,0.81,0.93,0.76,0.92,0.81,0.76,0.76,0.78300000000000003,0.70499999999999996,0.88005323558789128,0.76715025333625197,null,14.078032601792399,15.8221826339404,19.646585345264199,21.119678668660601,null,0.85833333333333339,0.755]
[10,0.73,0.56000000000000005,0.78,0.64,0.87,0.72,0.85,0.66,0.87,0.75,0.66,0.66,0.73299999999999998,0.65100000000000002,0.8013837324854417,0.67833942915093448,null,13.178359431900899,14.6233129390437,17.890342604176698,18.674712951793801,null,0.79333333333333333,0.66500000000000004]
[11,0.65,0.47,0.72,0.55000000000000004,0.82,0.64,0.76,0.53,0.81,0.71,0.55000000000000004,0.55000000000000004,0.66370378151260501,0.56289473684210534,{"$f":"P$38/X$38*X39","v":0.72562266533870878},{"$f":"Q$38/Y$38*Y39","v":0.58653409287486813},{"$nulls":6},0.71833333333333338,0.57500000000000007]
[12,0.59,0.4,0.67,0.47,0.76,0.56000000000000005,0.69,0.43,0.75,0.65,0.44,0.44,0.60056722689075626,0.48131578947368425,{"$f":"P$38/X$38*X40","v":0.65659591527168537},0.50152915187851044,{"$nulls":6},0.65,0.4916666666666667]
[13,0.54,0.36,0.62,0.41,0.7,0.49,0.64,0.33,0.67,0.6,0.36,0.36,0.54359033613445373,0.41605263157894734,0.59430348228437158,0.43352519908142423,{"$nulls":6},0.58833333333333326,0.42499999999999999]
[14,0.49,0.33,0.57999999999999996,0.35,0.64,0.44,0.6,0.23,0.6,0.55000000000000004,0.28000000000000003,0.28000000000000003,0.49123319327731096,0.35568421052631571,0.53706178710684016,0.37062154274411951,{"$nulls":6},0.53166666666666673,0.36333333333333329]
[{"$nulls":18},{"$f":"AVERAGE(S29:S38)","v":17.974753603351431},{"$f":"AVERAGE(T29:T38)","v":22.446094543928542},{"$f":"AVERAGE(U29:U38)","v":22.324314655965022},{"$f":"AVERAGE(V29:V38)","v":27.530041966112172}]
[]
[{"$nulls":18},"Source: Fern NMR/CIS",null,"Source: Fern NMR/CIS"]

{"sheet":"Lists","index":10,"n_rows":93,"n_cols":3,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
[]
["Feed to yield","High Peak yield and reduce feed as milk yields fall ,eg normal parlour feeding",1]
["Step rate","High peaks but cows fed in steps according to stage of lactation not yield",2]
["Flat rate","Lower peaks with one fixed level of concentrates fed to all cows",3]
["Total mixed ration","One mixed ration fed to all milking cows",4]
["Three times a day milking","TMR or partial mixed diet plus cake with 3x a day or robotic milking ",5]
["Once a day milking","Predominantly grazing system but cows only milked once per day",6]
["Spring block","Intensively grazed, grass based system",7]
["Autumn block","Herd fed to achieve maximum yield in winter and maximise grazing in spring",8]
[]
[]
["Month","Month number","Days"]
["2017-04-30",{"$f":"MONTH(A13)","v":4},{"$f":"DAY(A13)","v":30}]
["2017-05-31",{"$f":"MONTH(A14)","v":5},{"$f":"DAY(A14)","v":31}]
["2017-06-30",6,30]
["2017-07-31",7,31]
["2017-08-31",8,31]
["2017-09-30",9,30]
["2017-10-31",10,31]
["2017-11-30",11,30]
["2017-12-31",12,31]
["2018-01-31",1,31]
["2018-02-28",2,28]
["2018-03-31",3,31]
["2018-04-30",{"$f":"MONTH(A25)","v":4},{"$f":"DAY(A25)","v":30}]
["2018-05-31",5,31]
["2018-06-30",6,30]
["2018-07-31",7,31]
["2018-08-31",8,31]
["2018-09-30",9,30]
["2018-10-31",10,31]
["2018-11-30",11,30]
["2018-12-31",12,31]
["2019-01-31",1,31]
["2019-02-28",2,28]
["2019-03-31",3,31]
["2019-04-30",4,30]
["2019-05-31",5,31]
["2019-06-30",6,30]
["2019-07-31",7,31]
["2019-08-31",8,31]
["2019-09-30",9,30]
["2019-10-31",10,31]
["2019-11-30",11,30]
["2019-12-31",12,31]
["2020-01-31",1,31]
["2020-02-29",2,29]
["2020-03-31",3,31]
["2020-04-30",4,30]
["2020-05-31",5,31]
["2020-06-30",6,30]
["2020-07-31",7,31]
["2020-08-31",8,31]
["2020-09-30",9,30]
["2020-10-31",10,31]
["2020-11-30",11,30]
["2020-12-31",12,31]
["2021-01-31",1,31]
["2021-02-28",2,28]
["2021-03-31",3,31]
["2021-04-30",4,30]
["2021-05-31",5,31]
["2021-06-30",6,30]
["2021-07-31",7,31]
["2021-08-31",8,31]
["2021-09-30",9,30]
["2021-10-31",10,31]
["2021-11-30",{"$f":"MONTH(A68)","v":11},{"$f":"DAY(A68)","v":30}]
["2021-12-31",12,31]
["2022-01-31",1,31]
["2022-02-28",2,28]
["2022-03-31",3,31]
["2022-04-30",4,30]
["2022-05-31",5,31]
["2022-06-30",6,30]
["2022-07-31",7,31]
["2022-08-31",8,31]
["2022-09-30",9,30]
["2022-10-31",10,31]
["2022-11-30",11,30]
["2022-12-31",12,31]
["2023-01-31",1,31]
["2023-02-28",2,28]
["2023-03-31",3,31]
["2023-04-30",4,30]
["2023-05-31",5,31]
["2023-06-30",6,30]
["2023-07-31",7,31]
["2023-08-31",8,31]
["2023-09-30",9,30]
["2023-10-31",10,31]
["2023-11-30",11,30]
["2023-12-31",12,31]